Microsoft KB Archive/287492

= ACC2002: Subform in PivotChart or PivotTable View Extends Past Right Margin of the Page =

Article ID: 287492

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287492



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
If you print or print preview a form that contains a subform in PivotChart or PivotTable view, and the form is wider than either 8.5 inches (if no printer is installed) or the maximum possible width of your currently installed printer, the subform PivotChart or PivotTable is truncated.



CAUSE
Pivot charts do not respect page boundaries when you print a form or view a form in print preview.



RESOLUTION
Change the width of the form in Design view so that the form width is less than the page width required for the installed printer. If no printer is currently installed, change the width of the form in Design view so that the form is less than 8.5 inches wide.



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 Behavior

 * 1) In the Northwind database, open the Sales Analysis form in Design view. Increase the width of the form to at least 10 inches. Save the changes.
 * 2) Open the Sales Analysis form in Form view.
 * 3) Click the Show Pivot Table button.
 * 4) On the File menu, click Print Preview. Note that the pivot chart on this form extends past the form in print preview to the right of the page.

Additional query words: pra pivot chart table truncate chopped cut off print preview form

Keywords: kbbug KB287492

-

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

© Microsoft Corporation. All rights reserved.