Knowledge Base

Works: Database Report Prints Extra Pages

Article ID: 124913

Article Last Modified on 11/15/2004

APPLIES TO

This article was previously published under Q124913

SYMPTOMS

A database report may print extra pages that are blank or contain only the Headings rows (for example, the field names) or one or two horizontal lines. These extra pages will also be visible in print preview.

CAUSE and RESOLUTION

The resolution of the problem depends on the exact symptoms and cause, as listed below:

Extra Pages Contain Only Field Name Headers or Are Completely Blank

  • CAUSE 1: Extra Summary rows exist in report view. This can be caused by selecting a column (or the entire report) and changing the row height.

  • CAUSE 2: Extra columns exist in report view.

  • CAUSE 3: The database itself contains extra records (rows). This can be caused by selecting a column in list view and choosing Fill Down or Fill Series or by changing the row height.

  • CAUSE 4: The database itself contains a large number of blank records (rows) before the last record. This can be caused by selecting multiple rows in list view and inserting records.

    RESOLUTION (for all of the above): Select and delete the extra Record rows in list view, or extra Summary rows or columns in report view. See "More Information" below.

Extra Printed Pages Contain One or Two Horizontal Lines (Borders)

  • CAUSE: You tried to put a border around the report by highlighting the entire report, clicking Border from the Format menu, and then clicking Outline from the Border dialog box.

    RESOLUTION: Select the entire report and clear the Borders, using the steps below:

    1. From the Edit menu, click Select All.
    2. From the Format menu, click Border.
    3. Clear the Top, Bottom, Left, and Right selections, and click OK.

MORE INFORMATION

To remove extra records or rows that print at the end of your database or database report, do the following:

  1. Select the first blank record at the bottom of your database (in list view) or the first blank Summary row at the bottom of your report (in report view).
  2. Press SHIFT+CTRL+END to select the extra record rows or Summary rows. Make sure it is not highlighting any data.
  3. Works 4.0, 4.5, or 4.5a: From the Record menu, click Delete Record (in Database list view), or from the Insert menu, click Delete Row (in report view).

    Works 3.0: From the Insert menu, click Delete Record/Field (in Database list view) or Delete Row/Column (in report view).
  4. If the Delete dialog box appears, select Record (in Database list view) or Row (in report view). Click OK.

    WARNING: If Field (Database list view) or Column (report view) is selected at this point, all of the data will be deleted.
  5. If the following error message appears,
    Not enough memory to Undo: Continue?
    click OK.
The extra records or rows will now be deleted. Use a similar procedure to delete extra columns.

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto w_works database report view prints printing many extra additional multiple pages blanks clear

Keywords: kbprb KB124913


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.