Specify whether a group is expanded or collapsed by default 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 you want.

   Note   When you set the ExpandedByDefault property, you're specifying whether to show or hide the records in the next lower group level when the page is displayed in Page view or in Microsoft Internet Explorer.

4. In the ExpandedByDefault property box, do one of the following:
   • To open the page with the records in the next lower group level displayed, click Yes.
     
     
   • To open the page with the records in the next lower group level hidden, click No.

Note   The page will load faster in Page view and in Microsoft Internet Explorer if the ExpandedByDefault property is set to No for the highest group level on the page.