Software

Eliminate blank pages in your Access report

Margins can lead to extra blank pages in your Access report, potentially leading to waste and headaches. Here's how to change the Page Setup to streamline your report into just the length you desire.

When every other page of your 10-page Access report prints out blank, your first thought may be to change the report orientation from Portrait to Landscape. Rather than spend time redesigning your report layout, open the report in Design view and check the position of the report controls next to the right page margin. If any of the controls touch the right-margin border or even override it, Access automatically increases the right page margin to accommodate the controls. If this increases the margin past the eight-inch mark, Access cannot print the entire page on one piece of paper. (The blank page is actually a printout of the rest of the preceding page.) To eliminate the blank pages, follow these steps:

  1. Open the report in Design view.
  2. Click on the right border of any control that extends beyond the eight-inch right margin mark and drag it to the left so the control is within the margin.
  3. Repeat step 2 for each control extending beyond the margin.
  4. Go to File | Page Setup. (In Access 2007, click the Page Setup button in the Print Preview ribbon.)
  5. Click on the Column tab.
  6. Under Column size, click in Width text box and enter 8, then click OK.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks