Fix Blank Space in a Microsoft Access Report with a Subreport
Question details
Identify and remove excess blank space in an Access report that contains 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.
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.
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.
In Design View, select the subreport control. On the Property Sheet's Format tab, temporarily set Border Color to red.
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.
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.
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.
Open Print Preview and check records with both short and long subreport content. Restore the original colors after testing.

Check growth and shrink settings for the report
Use this check when the subreport or text fields have variable amounts of content.
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.

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.




