Microsoft KB Archive/287441

= ACC2002: &quot;Can Grow&quot; Property of PivotTable Subforms Is Ignored on Reports =

Article ID: 287441

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287441



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
When you use a PivotTable form as a subreport in a report in a Microsoft Access database or project, the subreport does not grow to accommodate all of its data. This behavior occurs even if both the subreport's Can Grow property and the report's Detail section's Can Grow property are set to Yes.



RESOLUTION
To resolve this issue, manually set the height of the subreport. To do this, use one of the following methods:
 * Type the Height value in the subreport's property sheet.

-or-
 * Resize the subreport by dragging the bottom border downward.



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 the Problem
These steps describe the behavior in an Access database. To reproduce the behavior in an Access project, use the sample project NorthwindCS.adp.

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) Start Access and open the sample database Northwind.mdb.
 * 2) Under Objects, click Forms, and then click New.
 * 3) Select AutoForm: PivotTable, click Order Details in the Choose the table or query where the object's data comes from list, and then click OK.
 * 4) From the PivotTable Field List, drag OrderID and ProductID to the Row Fields area, and then drag Quantity to the Totals or Detail area.
 * 5) On the standard toolbar, click Save, type Order Details PT in the Form Name box, click OK, and then close the form.

NOTE: You must use the Save button on the standard toolbar or close the form and choose to save when prompted. If you save the form by clicking the Save As command on the File menu, the data layout is not saved, although the form itself is.
 * 1) Under Objects, click Reports, and then click New.
 * 2) Click AutoReport: Tabular, click Orders in the Choose the table or query where the object's data comes from list, and then click OK.
 * 3) Click the Detail section of the report, and then if the property sheet is not visible, press F4.
 * 4) On the Format tab, click Height, type 1.0, and then press ENTER.
 * 5) On the Window menu, click Northwind: Database, and then click Forms under Objects.
 * 6) Drag the OrderDetailsPT form onto the Detail section of the report beneath the OrderID text box.
 * 7) On the Format tab of the property sheet, notice that the Can Grow property is Yes.
 * 8) On the View menu, click Print Preview.

Notice that the PivotTable subreport does not grow to accommodate all of its records as expected.

Additional query words: pra prb

Keywords: kbbug KB287441

-

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

© Microsoft Corporation. All rights reserved.