Specify whether a group is expanded or collapsed by default on a page

Microsoft Office Access 2003

Show All Show All

Specify whether a group is expanded or collapsed by default on a page

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.

  1. Open the data access page in Design view.
  2. Right-click the section bar of a section that belongs to the group whose settings you want to change, and then click Group Level Properties.
  3. In the ExpandedByDefault property box, do one of the following:
    • To open the page with the records in the next lower group level displayed, select True.
    • To open the page with the records in the next lower group level hidden, select False.

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