How to Print Mailing Labels with More Lines in Microsoft Access
Question details
The user needs to fit additional lines of text on mailing labels without leaving excess white space at the bottom of the label.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Designing and formatting label reports for batch printing mailing labels.
- Observed behavior
- The label report restricts the number of text lines that can be printed on a single label or leaves unwanted blank space at the bottom.
Verify the exact dimensions and the manufacturer product number of the physical labels you are using to ensure your software settings match your paper.
Adjust Font Size and Label Control Heights
Modify the design of your label report to reduce the space each line takes, allowing more lines to fit within the physical boundaries.
Microsoft Access calculates available space based strictly on the selected label dimensions. If you simply reduce the font size but leave the control height unchanged, Access will generate excess white space between the lines, limiting the number of lines you can add.
Right-click your label report in the Navigation Pane and select 'Design View'.
Select all text box controls on the label. Navigate to the 'Format' tab and reduce the font size to a smaller point size (e.g., 8 points).
With the controls still selected, manually drag the borders or use the Property Sheet to reduce the physical height of the controls to match the newly reduced font size.
Click on 'Page Setup' and review the top and bottom margins to ensure they are not taking up unnecessary space.

Select a Larger Label Template
If adjustments do not yield enough space for your required lines, switch to a larger Avery template.
Print Custom Mailing Labels with WPS Office
Instead of struggling with complex database report designers, you can easily create and print perfectly formatted mailing labels using the WPS Writer Mail Merge feature. Import your contact lists seamlessly and customize layouts without restrictive template limits.
- 1. Prepare Your Data: Open WPS Spreadsheet and ensure your contact list is organized with clear column headers like Name, Address, and City.
- 2. Open Mail Merge: Launch WPS Writer, navigate to the 'References' tab, and click 'Mail Merge' to start the feature.
- 3. Set Up the Layout: Design your label layout and insert the necessary merge fields, easily adjusting the font size and paragraph spacing to fit multiple lines.
- 4. Merge and Print: Click 'Merge to New Document' or 'Merge to Printer' to generate your customized labels effortlessly.

Frequently Asked Questions
Why is there too much white space at the bottom of my Access labels?
This usually happens if the height of the label controls in Design View is larger than necessary for the current font size, or if your page margins are set too high. Shrinking the control heights will eliminate excess white space.
Can I force Microsoft Access to print more lines on a standard label?
Access strictly respects the physical dimensions of the label template. To fit more lines, you must either reduce the font size and control heights or switch to a physically larger label template.
What is the minimum font size for readable mailing labels?
While you can technically use very small fonts, a font size of 8 points is generally considered the minimum for postal mailing labels to remain easily readable by mail carriers and automated sorting machines.
How do I change the Avery template number for an existing Access report?
You cannot directly change the Avery number of an existing label report. You must run the Label Wizard again from the Create tab to select the new Avery template and recreate the layout.




