Automatically show items or details in PivotTable view

Microsoft Office Access 2003

previous page next page

Show All Show All

Automatically show items or details in PivotTable view

  1. Open a datasheet or form in PivotTable view.
  2. On the PivotTable toolbar, click Properties Button image, and then click the Behavior tab.
  3. Do one or both of the following:

    ShowAutomatically show items

    • Set the Expand items by default option to Always.

    ShowAutomatically show details

    • Set the Expand details by default option to Always.

Note  To hide all items, set the Expand items by default option to Never. To hide detail data for all items, set the Expand details by default option to Never.

previous page start next page