ACC: Subreport Placed Low on Main Report Causes Blank Pages

Last reviewed: May 14, 1997
Article ID: Q117917

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you print or preview a report containing a subreport placed low in the main report's detail section, blank pages are generated after the subreport.

CAUSE

The extra pages are the result of the main report incorrectly determining where the subreport begins and ends.

RESOLUTION

Move the subreport higher in the main report's detail section, or create a static grouping section and place the subreport in that section. To create a static group footer, follow these steps:

Click the Sorting And Grouping button on the toolbar and type the following in the Field/Expression:
```
      ="A"
```
Then set the GroupFooter property to Yes.
Move the subreport from the detail section into the new group footer section.
Preview the report.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0, 1.1, and 2.0. This problem no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database NWIND.MDB.

Create a new, unbound report.

In the report's detail section, create three label controls with the following properties:

      Label1
         Name: Label1
         Caption: This is the top of the detail section.
         Top: 0
      Label2
         Name: Label2
         Caption: This is the middle of the detail section.
         Top: 10
      Label3
         Name: Label3
         Caption: This will print just above the subreport control.
         Top: 19.5

Create a subreport control in the detail section. Drag the Alphabetical List Of Products report to the subreport control.

Set the subreport control's properties as follows:

      Subreport Control
         Name: Alphabetical List of Products
         SourceObject: Report.Alphabetical List of Products
         Left: 0
         Top: 21
         CanGrow: Yes

Preview the report. Note that pages 6-11 are blank.

Keywords : kbusage RptSub
Version : 1.0 1.1 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.