Formatting Issues

Fix Uneven Can Shrink Spacing in Microsoft Access Reports

John WilsonJohn Wilson Oct 28, 2026 869 views

Question details

Users experience uneven gaps in Microsoft Access reports when empty fields fail to collapse, despite having the Can Shrink property enabled.

How to Fix Uneven Can Shrink Spacing in Microsoft Access Reports
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.
Before you start

Open your Microsoft Access database and identify the exact report name and the specific table fields that are failing to collapse.

Solution 1Recommended

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.

1
Modify Table Design

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.

2
Disable Zero Length Strings

In the Field Properties pane at the bottom, find the 'Allow Zero Length' property and change its value from 'Yes' to 'No'.

3
Run an Update Query

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).

4
Verify the Report

Open your report in Print Preview to confirm that the previously empty fields now shrink correctly and the line spacing is even.

Convert Zero-Length Strings to True Null Values
Data Cleanup Complete: By enforcing Null values, Access will now properly collapse the controls in your report, eliminating uneven line spacing.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the on-screen prompts to complete the lightweight installation.
  3. 3. Edit Your Documents: Instantly open and format your existing Office documents with a familiar, easy-to-use interface.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx)All-in-one suite combining Writer, Spreadsheet, Presentation, and PDF toolsRich layout and formatting controls to perfectly align your documentsFree to use, lightweight, and requires minimal system resources
microsoft office alternative - wps office

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.