You are currently offline, waiting for your internet to reconnect

When you create a Pivot Chart or a Pivot Table in Microsoft Office Access 2007, the Field List is not visible

Symptoms
When you create a Pivot Chart or a Pivot Table in Microsoft Office Access 2007, the Field List does not appear.
Cause

When the Current Database Document Window option in Microsoft Office Access Options is set to the default, "Tabbed Documents," the Field List is hidden behind the form even though the Ribbon Field List icon indicates it is not hidden.

Microsoft has confirmed this is a problem in Microsoft Office Access 2007.

Resolution
On the Ribbon Design tab in the Show/Hide group, click twice on the Field List icon.
More Information

The Field List will be visible in new Pivot Charts and Pivot Tables when the Current Database option for Document Window Options is "Overlapping Windows."

Steps to reproduce

  1. In the Northwind2007.accdb database, select the Customers table
  2. On the Ribbon Create tab in the Forms group, select PivotChart or select More Forms and PivotTable
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2012844 - Last Review: 05/25/2010 20:28:00 - Revision: 1.0

  • Microsoft Office Access 2007
  • KB2012844
Feedback