ACC2002: Cannot Change Title Bar Caption in PivotTables (282378)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q282378
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

In the PivotTable View of a table, you can create and format captions for the different data drop areas to assist users in displaying data as they would like to see it in a PivotTable. The areas to which you can assign captions are:

Filter drop area
Column drop area
Row drop area
Detail drop area

You can also set a caption for the report title bar. However, this caption does not appear in the PivotTable View of the table, nor in any printed version of the table.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
  2. Open the Orders table in Datasheet View.
  3. On the View menu, click PivotTable View.
  4. On the View menu, click Properties.
  5. In the Properties dialog box, on the Captions tab, in the Select caption box, select Detail drop area. Type My Details in the Captions text box. Under Format, change the Font Color to red and the Fill Color to yellow. Notice the change in the table.
  6. In the Select caption box, select Report title bar. Type My Test Caption in the Captions text box. Close the Properties dialog box.
Note that the title bar does not change, and the report title bar caption does not appear in any view of the table.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug kbpending KB282378
©2003 Microsoft Corporation. All rights reserved.