March 12, 2008

Eliminate blank pages in your Access report

Date: March 11th, 2008

Author: Mary Ann Richardson

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:

Open the report in Design view.
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.
Repeat step 2 for each control extending beyond the margin.
Go to File | Page Setup. (In Access 2007, click the Page Setup button in the Print Preview ribbon.)
Click on the Column tab.
Under Column size, click in Width text box and enter 8, then click OK.