Printing Problems

How to Print Mailing Labels with More Lines in Microsoft Access

Rana GarciaRana Garcia Nov 2, 2026 868 views

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.

How to Print Mailing Labels with More Lines in Access
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.
Before you start

Verify the exact dimensions and the manufacturer product number of the physical labels you are using to ensure your software settings match your paper.

Solution 1Recommended

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.

1
Open Design View

Right-click your label report in the Navigation Pane and select 'Design View'.

2
Reduce Font Size

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

3
Adjust Control Height

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.

4
Check Margins

Click on 'Page Setup' and review the top and bottom margins to ensure they are not taking up unnecessary space.

Adjust Font Size and Label Control Heights
Measurement Constraints: Keep in mind that there are 72 points in an inch. Five lines of 8-point text will use more than half of a one-inch label. Adjustments must be precise.
Print Labels Easily

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. 1. Prepare Your Data: Open WPS Spreadsheet and ensure your contact list is organized with clear column headers like Name, Address, and City.
  2. 2. Open Mail Merge: Launch WPS Writer, navigate to the 'References' tab, and click 'Mail Merge' to start the feature.
  3. 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. 4. Merge and Print: Click 'Merge to New Document' or 'Merge to Printer' to generate your customized labels effortlessly.
Seamlessly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mail Merge wizard with highly flexible line spacing and formatting.Easily adjust font sizes and control margins without strict template limitations.Free, lightweight, and requires significantly fewer system resources.
microsoft office alternative - wps office

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.