Search code examples
ms-accessprintingms-access-2016

MS Access: Printing blank pages despite correct margins

  • I am printing warehouse slot labels to a label printer with a 4" x 2" roll of labels.
  • I have an MS Access report which divides each label into its own page.
  • The labels are just an alphanumeric string of 5 digits.
  • The detail section of my report is just 3.5" wide.
  • The margins are set to 0.1" Left and Right.
  • Vertical margins are set to 0.25" and are not an issue.
  • Printing labels yields a blank label after every correctly printed label.
  • All labels do eventually get printed, but with double the amount of time and labels used.
  • I receive the following error message whenever I open Print Preview or close Page Setup:

The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank.

So here is my question: Why are my correctly sized labels printing off the page?

TIA

Solution

  • I found the solution:

    Print Preview -> Page Setup -> Columns -> Column Size -> Check the box marked "Same As Detail"

    Apparently, Access automatically assigned a column width that was the same size as the entire page (4"). This conflicted with the page's borders and triggered the blank pages.