• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Printing Basic Reports and M... > Preventing Widowed Records with the ...

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 to the group that you want to keep together. In this example, select CategoryID.

3.
Open the Keep Together drop-down list and select Whole Group, as shown in Figure 14.35.

Figure 14.35. Setting the report group's Keep Together property.


4.
Close the Sorting and Grouping dialog, and click the Report View button to see the result of applying the group Keep Together property.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint