ACC2002: "Can Grow" Property of PivotTable Subforms Is Ignored on Reports (287441)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

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.
  6. Under Objects, click Reports, and then click New.
  7. Click AutoReport: Tabular, click Orders in the Choose the table or query where the object's data comes from list, and then click OK.
  8. Click the Detail section of the report, and then if the property sheet is not visible, press F4.
  9. On the Format tab, click Height, type 1.0, and then press ENTER.
  10. On the Window menu, click Northwind: Database, and then click Forms under Objects.
  11. Drag the OrderDetailsPT form onto the Detail section of the report beneath the OrderID text box.
  12. On the Format tab of the property sheet, notice that the Can Grow property is Yes.
  13. On the View menu, click Print Preview.

    Notice that the PivotTable subreport does not grow to accommodate all of its records as expected.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug KB287441
©2003 Microsoft Corporation. All rights reserved.