Microsoft Office Tutorials and References
In Depth Information
Formatting the Page
Don’t place page-break controls in the Page Header or Page Footer section.
Doing so starts a new page at the top or bottom of every page, which just
creates confusion (and an error). You can put a page break in the Report
Header or Report Footer, though, if you have multipage cover sheets.
Avoiding blank pages
Almost every Access user winds up with blank pages in a report. The blank
pages appear in Print Preview, but what causes them?
Access knows the width of your paper and how much space to leave for the
left and right margins because these sizes are specified in the report’s
property sheet. Access adds the width of your report to the left and right margins
to come up with the total width of the printed report. If the total is wider
than your paper, Access splits the report into vertical bands and prints the
left and right halves of the report on separate pieces of paper, so you can
tape them together to create a very wide report.
If the report is just a little bit too wide to fit across one piece of paper, all
the text of the report is printed on the left half, leaving the right half blank.
These blank right halves are the blank pages that Access prints. If the right
part of the report has no controls in it, Access alerts you to this fact with
The section width is greater than the page width, and there are no items
in the additional space, so some pages may be blank.
To get rid of the blank pages, follow these steps:
1. Click the File tab on the Ribbon, and choose Options ➪ Client Settings
to display the Access Options dialog box.
2. Scroll down to the Printing section.
You see something that looks like Figure 2-5, earlier in this chapter.
3. Subtract the left and right margin settings from the width of your
paper to get the maximum width of the report.
Standard U.S. paper is 8 1 ⁄ 2 inches wide. If the left and right margins are
too wide, make them smaller in this dialog box and then use the new
values in your calculation. If your paper is 8 1 ⁄ 2 inches wide, and you
have half-inch left and right margins, your report can’t be more than 7 1 ⁄ 2
You can change the margins if you want to use different defaults.
4. Click OK to exit the Access Options dialog box.
5. With the report open in Design view, note the report’s width — the
location along the ruler of the right edge of the grid area.