Microsoft Access 2010 Bible

Part I: Access Building Blocks

372

The Title button in the Header/Footer group adds the report’s name as the report header’s title, and

positions the edit cursor within the title label to make it easy for you to adjust the report’s title.

Finally, the Date and Time button opens the Date and Time dialog box (shown in Figure 9.39).

Specify the date and time format you’d like to use for the date control by selecting the Date and

Time control in the Header/Footer group in the ribbon’s Design tab.

FIGURE 9.39

Specifying the date and time format

The completed report in Print Preview is shown in Figure 9.40. The report header in this figure

was created in less than a minute using the tools built into Access 2010.

Caution
If every even-numbered page is blank, you accidentally widened the report past the 8-inch mark. If you move a
control to brush up against the right page-margin border or exceed it, the right page margin increases automat-
ically. When it’s past the 8-inch mark, it can’t display the entire page on one piece of paper. The blank page
you get is actually the right side of the preceding page. To correct this, make sure that all your controls are
within the 8-inch right margin; then drag the right page margin back to 8 inches.

As you close the report, Access will prompt you for the report’s name.