Microsoft KB Archive/117917

= ACC: Subreport Placed Low on Main Report Causes Blank Pages =

Article ID: 117917

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q117917



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



SYMPTOMS
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:


 * 1) 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.
 * 1) Move the subreport from the detail section into the new group footer section.
 * 2) 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.



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.</li>  Set the subreport control's properties as follows:

<pre class="fixed_text">     Subreport Control Name: Alphabetical List of Products SourceObject: Report.Alphabetical List of Products Left: 0 Top: 21 CanGrow: Yes </li> Preview the report. Note that pages 6-11 are blank.</li></ol>

Keywords: kbbug kbusage KB117917

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.