Preventing Widowed Records with the Group Keep Together Property

Access includes a Keep Together property for groups that prevents widowed records from appearing at the bottom of the page. Depending on your report section depths, you might find that only a few records of the next group (called widowed records) appear at the bottom of the page. You can force a page break when an entire group does not fit on one page by following these steps:

1.
With the report in Design view, click the toolbar's Sorting and Grouping button to open the Sorting and Grouping dialog.
2.
Select the field with the group symbol in the selection button that corresponds ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.