Printing Problems

Fix Microsoft Access Address Labels Incorrect Spacing

WPS Content ManagerWPS Content Manager Oct 10, 2026 868 views

Question details

The user needs to correct the vertical spacing on an address label report that is printing improperly.

Fix Microsoft Access Address Labels Incorrect Spacing
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 you start

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.

Solution 1Recommended

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.

1
Open the Report in Design View

In the Access Navigation Pane on the left, right-click your label report and select 'Design View' from the context menu.

2
Remove Unnecessary Headers and Footers

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.

3
Set the Detail Section Height

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

4
Verify Page Setup and Margins

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.

Adjust Report Sections and Detail Height in Design View
Testing Your Print Alignment: Before wasting real label sheets, print a test page on standard blank printer paper and hold it up to the light against a physical label sheet to verify the vertical spacing is correct.
Free Microsoft Office alternative

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. 1. Export Your Data: Export your Microsoft Access contacts to a standard Excel (.xlsx) or CSV file.
  2. 2. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab to open the Mail Merge toolkit.
  3. 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.
Free and lightweight Office suite with a familiar interfaceExcellent format compatibility with Microsoft Word (.docx) and Excel (.xlsx)Intuitive built-in Mail Merge feature to effortlessly generate and print address labelsNo complex database report formatting required
QA img-9

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.