Fix Uneven Can Shrink Spacing in Microsoft Access Reports
Question details
Users experience uneven gaps in Microsoft Access reports when empty fields fail to collapse, despite having the Can Shrink property enabled.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Formatting a database report to hide empty rows and compress layout space.
- Observed behavior
- Report controls fail to shrink and leave blank gaps because the underlying fields contain spaces or zero-length strings instead of true Null values.
Open your Microsoft Access database and identify the exact report name and the specific table fields that are failing to collapse.
Convert Zero-Length Strings to True Null Values
The Can Shrink property only activates for true Null values. You must configure the table to disallow zero-length strings and clean up existing hidden spaces.
If a field contains a zero-length string ("") or a space character, Access considers it populated and will not shrink the control. Adjusting the table design ensures new records are stored as Null when empty, resolving the spacing issue.
Right-click your source table in the Navigation Pane and select 'Design View'. Click on the field that is causing the blank spaces in your report.
In the Field Properties pane at the bottom, find the 'Allow Zero Length' property and change its value from 'Yes' to 'No'.
To fix existing data, go to the Create tab, select 'Query Design', and change it to an 'Update Query'. Update the problematic field to Null where the criteria is "" (a zero-length string) or " " (a single space).
Open your report in Print Preview to confirm that the previously empty fields now shrink correctly and the line spacing is even.

Verify Property Sheet Settings for Report Sections
Even if the text box is set to shrink, the section containing the text box must also be allowed to shrink.
Looking for a Lightweight, Free Office Suite?
While WPS Office does not include a database management tool like Access, it is an exceptionally powerful, free alternative to Microsoft Word, Excel, and PowerPoint. If you are looking for a highly compatible suite for your daily document formatting and reporting needs, WPS Office provides a seamless transition.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the setup file and follow the on-screen prompts to complete the lightweight installation.
- 3. Edit Your Documents: Instantly open and format your existing Office documents with a familiar, easy-to-use interface.

Frequently Asked Questions
Why does the Can Shrink property ignore empty fields in my Access report?
The Can Shrink property strictly requires the field's underlying value to be Null. If a user presses the spacebar, or if the database saves an empty field as a zero-length string (""), Access treats the field as containing data and will not collapse it.
Do I need to enable Can Shrink on both the text box and the report section?
Yes. For the blank space to physically disappear from the report layout, both the individual text box control and the section containing it (e.g., the Detail section) must have their Can Shrink properties set to Yes in the Property Sheet.
How do I prevent zero-length strings from being entered in the future?
Open the relevant table in Design View, select the text field, and look at the Field Properties at the bottom of the screen. Change the 'Allow Zero Length' property to 'No'. This forces Access to store empty entries as Null.




