Chapter 9: Presenting Data with Access Reports
369
The next step is to add a nice thick line separating the Page Header section from the Category
Group Header section:- Select the Line tool in the Controls ribbon group.
- Place the mouse cursor near the far left side of the Page Header, just to the right and
above the 1-inch mark on the vertical toolbar, as shown in Figure 9.37.
FIGURE 9.37
Adjusting controls in the page header- Hold down the Shift key and drag the mouse across the page header, releasing it just to
the left of the 7^1 ⁄ 2 -inch mark.
Holding down the Shift key forces a nice, straight, horizontal line.
- Select the line and select the 2 pt Border Width property from the line’s property
window.
Creating an expression in the group header
Figure 9.37 also shows that the Category field has been replaced by an expression. If you place
the value of the category in the Group Header section, it looks out of place and may not be readily
identifiable. Most data values should have some type of label to identify what they are.The expression =“Category: “ & [Category] displays Category: followed by a space and
the value of the Category field (such as Category: Cars) in the text box. The & symbol (the
concatenation operator) joins strings. Make sure you leave a space after the colon or the value
won’t be separated from the label. The text control has been bolded and underlined, and the font
point size has been increased as well.