Show or hide the field list

ShowIn Design view

ShowIn PivotTable view or PivotChart view

Use the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.) to view the list of fields that are available from the underlying database object and to add fields to the different areas in the view.

  1. Open a datasheet or form in PivotTable view (PivotTable view: A view that summarizes and analyzes data in a datasheet or form. You can use different levels of detail or organize data by dragging the fields and items or by showing and hiding items in the drop-down lists for the fields.) or PivotChart view (PivotChart view: A view that shows a graphical analysis of data in a datasheet or form. You can see different levels of detail or specify the layout by dragging fields and items or by showing and hiding items in the drop-down lists for the fields.).
  2. Click Field List Button image on the PivotTable or PivotChart toolbar.

Notes

  • In the field list, the fields that are not bold are available but are not yet displayed in the view. The fields that appear in bold are already displayed in the view.
  • You can scroll and click the expand indicators (Plus box or Minus box boxes) in the field list to show or hide additional fields.
 
 
Applies to:
Access 2003