Knowledge Base |

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

1. Open the sample database NWIND.MDB.
2. Create a new, unbound report.
3. 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

4. Create a subreport control in the detail section. Drag the Alphabetical List Of Products report to the subreport control.
5. 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

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

Keywords: kbbug kbusage KB117917