Fix Microsoft Access Address Labels Incorrect Spacing
Question details
The user needs to correct the vertical spacing on an address label report that is printing improperly.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Printing an address label report after a database has been upgraded or transferred between different versions of Access.
- Observed behavior
- The label report prints fewer labels per page than expected and displays excessive vertical spacing between the rows of labels.
Before modifying the report design, carefully measure your physical label sheet to confirm the exact height of a single label and the specific page margins required by the manufacturer.
Adjust Report Sections and Detail Height in Design View
Removing unnecessary report sections and strictly matching the Detail section height to your physical label height resolves most alignment issues.
When transferring an Access database between versions, default report properties and page margins can sometimes shift. This causes headers and footers to expand, which disrupts the precise alignment needed for label grids.
In the Access Navigation Pane on the left, right-click your label report and select 'Design View' from the context menu.
Right-click the report background and ensure that 'Page Header/Footer' and 'Report Header/Footer' are unchecked or deleted. Only the 'Detail' section should remain visible.
Click directly on the Detail section background. Open the Property Sheet (press F4), find the 'Height' property under the Format tab, and set it exactly to your label height (e.g., 1 inch for a standard 2 5/8-by-1-inch label).
Go to the Page Setup tab on the ribbon. Check the Margins to ensure they match your label sheet, and click the 'Columns' button to verify that the column size and spacing perfectly match the physical label dimensions.

Print Address Labels Easily with WPS Office
Troubleshooting report designs in Microsoft Access can be tedious. A simpler alternative is to export your mailing list and use WPS Office. WPS provides a highly compatible, free Office suite with a straightforward Mail Merge feature for perfect address labels.
- 1. Export Your Data: Export your Microsoft Access contacts to a standard Excel (.xlsx) or CSV file.
- 2. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab to open the Mail Merge toolkit.
- 3. Merge and Print Labels: Select your exported Excel file as the data source, set up your label dimensions using the built-in templates, insert your address fields, and print perfectly spaced labels.

Frequently Asked Questions
Why did upgrading my Access version change my label spacing?
Different versions of Microsoft Access interpret default printer margins and legacy report formatting slightly differently. This conversion can inadvertently add height to page footers or margins, shifting your labels downward.
How do I fix labels printing sequentially across the page instead of down the column?
Open your report in Design View, click 'Page Setup' on the ribbon, and open the Page Setup dialog box. Navigate to the 'Columns' tab and change the Column Layout setting from 'Across, then Down' to 'Down, then Across'.
What if my labels are still slowly creeping down the page?
This is called 'label creep' and usually means the Detail section height or the top/bottom page margins are off by a fraction of an inch. Re-measure your physical labels and adjust the Detail section height in the Property Sheet by a few hundredths of an inch to compensate.




