Printing Problems

Fix Access Avery 5160 Labels Printing in Wrong Layout

Rana GarciaRana Garcia Nov 4, 2026 868 views

Question details

The user needs to fix an MS Access report where Avery 5160 labels incorrectly switch from a 3-column format to a 1-column layout upon reopening.

Fix Access Avery 5160 Labels Printing in the Wrong Layout
Product
Microsoft Access
Device & OS
Windows 10
Scenario
Printing label reports in Microsoft Access using Avery 5160 templates.
Observed behavior
The report opens and prints in a single-column layout instead of the expected 3-column, 30-labels-per-page format.
Before you start

Ensure that your printer is turned on, connected, and set as the default printer in Windows, as Access report layouts heavily rely on the active default printer settings to render margins correctly.

Solution 1Recommended

Switch to Print Preview and Adjust Column Settings

Access may default to 'Report View', which displays labels in a single continuous column. Switching to 'Print Preview' reveals the true layout and allows you to enforce the 3-column setup.

Report View is optimized for scrolling through data on a screen, ignoring print-specific formatting like columns and margins. You must use Print Preview to see and modify the physical label layout.

1
Open Print Preview

Right-click the report tab in Microsoft Access and select 'Print Preview' instead of 'Report View'.

2
Access Page Setup

Navigate to the 'Page Setup' tab on the ribbon and click 'Columns'.

3
Configure Columns

In the Page Setup dialog, ensure the 'Number of Columns' is set to 3, and verify the width and height match the Avery 5160 standard.

4
Save Layout

Save the report while still in Print Preview mode so Access remembers the layout settings for future use.

Switch to Print Preview and Adjust Column Settings
Free Microsoft Office alternative

Experience Seamless Productivity with WPS Office

While WPS Office does not feature a direct database alternative to MS Access, it provides a comprehensive, lightweight, and free suite for all your document, spreadsheet, and presentation needs. If you need to print labels, you can easily export your Access data to WPS Spreadsheet and use WPS Writer's Mail Merge feature to print perfectly aligned Avery labels.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free software package for your operating system.
  2. 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to complete the installation.
  3. 3. Open and Edit Files: Launch WPS Office and immediately start opening, editing, and saving your Microsoft Office documents with perfect formatting.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint formats.Easily format and print labels by combining exported database data with WPS Writer.Lightweight design that runs smoothly on both older and modern Windows systems.Free to use with a familiar, user-friendly interface that makes migration effortless.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Avery labels show as one continuous column in Report View?

Report View in MS Access is designed specifically for scrolling through data on a screen and does not apply print-specific formatting like column breaks or margins. You must switch to Print Preview to see your labels in the standard 3-column Avery 5160 format.

Can changing my default printer mess up my Access report layout?

Yes. Microsoft Access calculates margins and page layouts dynamically based on the current default printer's drivers. If the default printer changes, Access may recalculate the page setup, causing labels to misalign or unexpectedly drop to a single column.

What are the correct page setup dimensions for Avery 5160 labels in Access?

For Avery 5160 labels, you should configure 3 columns. In the Page Setup dialog, set the column width to 2.625 inches and the height to 1 inch per label. Ensure your paper size is set to standard Letter (8.5 x 11 inches) and the margins accommodate the label grid.