Microsoft Office Tutorials and References
In Depth Information
Creating and Managing Report Sections
Adding page numbers
When you have a Page Header or Footer section to put controls in, you can
create controls in that section or drag the controls there from other
sections. The easiest way to add page numbers — probably among the most
common controls that you’ll find on reports — is to click the Page Numbers
button in the Header/Footer group on the Design tab of the Ribbon. When
you see the Page Numbers dialog box (shown in Figure 1-11), choose the
format of the numbering, the position, and the alignment (Left, Center, Right,
Inside, or Outside). Inside and Outside page numbering refer to alternating
left and right positions on odd and even pages. You can omit the page
number on the first page by deselecting the Show Number on First Page
check box. Click OK to save your changes.
If you’d rather make your own page-numbering controls, you can create your
own text box control by following these steps:
1. Open the report in Design view.
2. Create a text box control in the Page Header or Footer section by
clicking the Text Box button in the Controls group on the Design tab
of the Ribbon and then clicking the Header or Footer section.
Don’t worry if the text box doesn’t appear in exactly the right place; you
can drag it there later.
3. If Access created a label to go with the text box, delete the label by
clicking the label and then pressing the Delete key.
Your page number doesn’t need a label!
4. Click the Property Sheet button in the Tools group on the Design tab
of the Ribbon to display the property sheet, if it’s not already
You see the property sheet with the properties of the text box you
5. Click the Data tab on the property sheet, click the Control Source
property, and type the following expression: