ACC2002: Subform in PivotChart or PivotTable View Extends Past Right Margin of the Page (287492)


The information in this article applies to:

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

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug KB287492
©2003 Microsoft Corporation. All rights reserved.