Microsoft Access 2010 Bible

Part I: Access Building Blocks

352

To make the titles stand out, follow these steps to modify the appearance of label text:

1. Click the newly created report heading Product Display label.


2. Click the Formatting ribbon tab, and select the Bold button in the Font group on the ribbon.


3. From the Font Size drop-down list, select 18.


4. Repeat for the Collectible Mini Cars label, using a 12 pt Arial font and Bold.

The size of the labels may not fit their displayed text. To tighten the display or to display
all the text when a label isn’t big enough, double-click any of the sizing handles, and
Access chooses an appropriate size for the label.

Figure 9.29 shows these labels added, resized, and formatted in the report’s Page Header
section.

FIGURE 9.29

Adding unbound labels to the report

Working with text boxes

So far, you added controls bound to fields in the tables and unbound label controls used to display

titles in your report. There is another type of text-box control that is typically added to a report:

unbound text boxes that are used to hold expressions such as page numbers, dates, or a calculation.

Adding and using text-box controls

In reports, text-box controls serve two purposes:

l They enable you to display stored data from a particular field in a query or table.

l (^) They display the result of an expression.
Expressions can be calculations that use other controls as their operands, calculations that use
Access functions (either built in or user defined), or a combination of the two.