Show All

Set the number of records to display in a group

1. Open the data access page in Design view.
2. Scroll to a section that belongs to the group for which you want to specify the setting.
3. Right-click the section bar, and then click Group Level Properties.
4. In the DataPageSize property box, select a value from the list or type a value in the box.

Notes

• If a group level doesn't have a record navigation section or a record navigation control, you must set the DataPageSize property to All in order to see all the records for that group level. If that group level is the only group level on the page or the highest group level on the page, and if a page contains many records, it might take longer to load the page.

• You cannot set the DataPageSize property of a group level to a value other than 1, if any of its sections include a PivotTable list, spreadsheet, or chart.