Microsoft KB Archive/282378

= ACC2002: Cannot Change Title Bar Caption in PivotTables =

Article ID: 282378

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

Additional query words: pra prb

Keywords: kbbug kbpending KB282378

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.