Formatting Issues

Fix Blank Space in a Microsoft Access Report with a Subreport

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Identify and remove excess blank space in an Access report that contains a subreport.

Fix Blank Space in an Access Report with a Subreport
Product
Microsoft Access
Device & OS
not provided
Scenario
A main report contains a subreport with variable numbers of records or fields that can grow to multiple lines.
Observed behavior
Blank space remains in the report even when controls use Can Grow and Can Shrink.
Before you start

Open the report in Design View and display the Property Sheet using F4. Identify the main report's Detail section, the subreport control, and any nearby image or photo controls.

Solution 1Recommended

Find controls that extend the main report section

Use contrasting colors to locate the blank area, then adjust any control that keeps the section too tall.

1
Color the subreport outline

In Design View, select the subreport control. On the Property Sheet's Format tab, temporarily set Border Color to red.

2
Color the Detail section

Select the main report's Detail section and set its Back Color to yellow on the Property Sheet. Open Report View or Print Preview to see which area contains the blank space.

3
Inspect nearby controls

Return to Design View and check for controls whose bottom edges extend below the subreport, including photo or image controls. A control extending lower can prevent the section from shrinking further.

4
Adjust the layout

Resize or reposition the subreport and nearby controls as appropriate. If a photo box extends below the subreport, try aligning their bottom edges, then drag the Detail section's bottom boundary upward if needed.

5
Preview the report

Open Print Preview and check records with both short and long subreport content. Restore the original colors after testing.

Find controls that extend the main report section
Keep the layout readable: After resizing controls, check that photos and subreport content are not clipped or overlapping.
Free Microsoft Office alternative

Work with Office Documents Using WPS Office

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations in a familiar interface. It supports common Microsoft Office formats for easier migration, but it does not fix Access report layouts.

Create and format reports in WPS WriterWork with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXUse a familiar interface to make the transition from Microsoft Office easierInstall a lightweight office suite for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why is there blank space below my Access subreport?

A control on the main report, such as a photo box, may extend below the subreport and keep the Detail section taller. Check the controls and section boundary in Design View.

How can I tell whether the space is in the main report or the subreport?

In Design View, temporarily give the subreport control a contrasting Border Color and the main report Detail section a different Back Color. Then inspect the result in Print Preview.

Why does blank space remain when Can Shrink is set to Yes?

Can Shrink may not remove the space if another control extends farther down or the section layout requires more height. Inspect the main report's nearby controls and Detail section boundary.

Where do I change Can Grow and Can Shrink?

Open the report or subreport in Design View, select the relevant control or section, and press F4. Find Can Grow and Can Shrink on the Property Sheet's Format tab.

Can WPS Office fix an Access subreport?

No. Adjust the subreport and section layout in Microsoft Access. WPS Office is an alternative for documents, spreadsheets, and presentations, not an Access report editor.