ACC2: Extra White Space Between Last Section and Report Footer

Last reviewed: May 14, 1997
Article ID: Q116061
The information in this article applies to:
  • Microsoft Access version 2.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

There is extra white space on your report after the last detail record or section of the report, before the report footer section prints. The extra white space is as tall as the detail section height. Note that this problem occurs only with reports that have a report footer section.

This problem can occur with reports created in Microsoft Access version 2.0, and with reports created in Microsoft Access version 1.x that you are using in version 2.0.

RESOLUTION

Change the report to have a vertical layout by following these steps:

  1. Open the report in Design view. From the File menu, choose Print Setup. Choose the More button.

  2. In the Items Across box, enter "2" (without quotation marks).

  3. In the Item Layout area, select the Vertical option button.

  4. In the Items Across box, enter "1" (without quotation marks).

  5. Choose OK.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the sample database NWIND.MDB.

  2. Open the Alphabetical List Of Products report in Design view.

  3. Increase the height of the report footer section to 1 inch.

  4. Set the report footer section's BackColor property to 16711680 (blue).

  5. Set the Product Name footer section's BackColor property to 255 (red). (NOTE: Changing the sections' colors helps to illustrate the problem.)

  6. Preview the report. Note the extra white space between the Product Name footer (red) and the report footer (blue).

  7. Close the report without saving the changes.


Additional query words: line spacing whitespace canshrink blank
Keywords : kbusage RptLayou
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.