Specify the number of records to display in a group on a data access page

1. Open the data access page in Design view.
   
   
2. Click Sorting And Grouping on the toolbar to display the Sorting And Grouping box.
   
   
3. Click the group record source for which you want to specify the number of records to display.
   
   
4. In the DataPageSize property box, click a value in the list or type a value in the box.

If you set DataPageSize to All for a group level, and that group level is the only group level on the page or the highest group level on the page, all the records will be displayed when you open the page in Page view or in Microsoft Internet Explorer. If a page contains many records, it might take longer to load the page.

Note   If a group level doesn't have a record navigation section or a record navigation control, you must set DataPageSize to All in order to see all the records for that group level.