Database Reference
In-Depth Information
Removing the alternate row color makes the structure of this report more obvious.
Next let's format the text in the controls. It is usually most efficient to change the
character formatting of all the controls and then adjust the ones you want to be
different.
18
Click any control, and then on the
Format
tool tab, in the
Selection
group, click the
Select All
button.
KEYBOARD SHORTCUT
Press Ctrl+A to select all the controls.
19
In the
Font
group, click the
Font Size
arrow, and then click
9
.
20
Click the report's title control, and then use the commands in the
Font
group to
make the text
24
points,
Bold
, and dark green. (We chose the fifth swatch in the
ninth column,
Olive Green, Accent 5, Darker 25%.
)
21
Select the controls in the group header, and make them bold and dark green.
22
Scroll the report, noticing that a few of the values in the
Units In Stock
column are
0
.
Let's make zero values bold and red so that they stand out in the report and alert
buyers that it is time to order more of these products.
23
Click any control in the
Units In Stock
column. Then in the
Control Formatting
group,
click the
Conditional Formatting
button to open the
Conditional Formatting Rules
Manager
.