ACC2002: PivotChart Subform Is Printed Outside of Margins and Is Repeated on Second Page (286600)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q286600
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 print a form that contains a subform in PivotChart view, the PivotChart ignores the right margin of the page, and some portions of the PivotChart are duplicated on subsequent pages. For example, a subform PivotChart that spans two pages will duplicate the legend on both pages.

CAUSE

The width of the subform, plus the right and left margins, exceeds the paper size that you currently have selected.

RESOLUTION

Use one of the following workarounds.

Change Print Options So That the PivotChart Is Printed on One Page

Change the printer options so that the PivotChart is printed on one page. For example, by reducing the left and right margins and changing the orientation to landscape, you may be able to fit the PivotChart on one page. For an example of how to change printer options for a form, follow these steps:
  1. Open the sample database Northwind.mdb.
  2. Open the Sales Analysis form.
  3. Click Show PivotChart to view the subform in PivotChart view.
  4. On the File menu, click Page Setup.
  5. On the Margins tab, reduce the Left and Right margins to .5" each.
  6. Click the Page tab.
  7. Click the Landscape under Orientation.
  8. Click OK to close the Page Setup dialog box.
Note that the PivotChart previews correctly on one page.

Reduce the Width of the Subform in Design View of the Main Form

The PivotChart view of a subform is sized to fit within the subform control. When you print preview the main form, the width of the PivotChart is dictated by the width of the subform that contains it. By reducing the width of the subform in Design view of the main form, you can reduce the width required to display the subform in PivotChart view and during printing. For an example of how to change the size of a subform in PivotChart view, follow these steps:
  1. Open the sample database Northwind.mdb.
  2. Open the Sales Analysis form in Design view.
  3. On the View menu, click Properties to display the property sheet.
  4. Click the arrow in the combo box at the top of the property sheet, and then click Sales Analysis Subform1.
  5. Click the Format tab.
  6. Set the Width property to 6".
  7. Click the arrow in the combo box at the top of the property sheet again, and then click Form.
  8. Click the Format tab.
  9. Set the Width property to 6.5".
  10. On the File menu, click Save.
  11. On the View menu, click Form View.
  12. Click Show PivotChart.
  13. On the File menu, click Print Preview.
Note that the PivotChart previews correctly on one page.

Open the Subform Separately from the Main Form

Open and print the subform separately from the main form. The PivotChart view of a main form is always fitted to print on one page, regardless of the page settings. Therefore if you open the subform separately from the main form, you can preview or print it without the legend being duplicated on multiple pages.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

When the width of the subform plus the left and right margins exceeds the current paper size, the PivotChart ignores the right margin setting and prints to the right edge of the page. On the second page, the PivotChart repeats everything that was printed outside of the margin on the first page.

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Open the Sales Analysis form.
  3. Click Show PivotChart to view the subform in PivotChart view.
  4. On the File menu, click Print Preview. Note that the columns for the first and second quarters of 1998 are printed on the first page and the legend is printed in the right margin.
  5. Advance to the second page.
Note that the columns for the first and second quarters of 1998 and the legend are repeated on the second page.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbnofix kbprint KB286600
©2003 Microsoft Corporation. All rights reserved.