Fix Access Avery 5160 Labels Printing in Wrong Layout
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.

- 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.
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.
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.
Right-click the report tab in Microsoft Access and select 'Print Preview' instead of 'Report View'.
Navigate to the 'Page Setup' tab on the ribbon and click '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.
Save the report while still in Print Preview mode so Access remembers the layout settings for future use.

Verify Default Printer Configuration
Access formats reports based on the default printer's drivers. Changing or losing the default printer can alter the label layout.
Upgrade to a Modern Version of Access
Older versions like Access 2000 are obsolete and exhibit severe compatibility and printing rendering issues on modern operating systems like Windows 10.
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. Download the Installer: Visit the official WPS Office website and download the free software package for your operating system.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open and Edit Files: Launch WPS Office and immediately start opening, editing, and saving your Microsoft Office documents with perfect formatting.

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.




