Microsoft Office Tutorials and References
In Depth Information
Creating Mailing Labels
The first line of the label in Figure 2-10 contains a text box with this
expression as its Control Source property:
=Trim([First Name] & [Last Name])
This scary-looking expression glues the first name, a space, and the last
name together and then discards any spaces at the right end.
If you don’t like the way that information appears on your mailing labels, you
can delete the text boxes, add new ones, alter the expressions in the existing
text boxes, and change the formatting of the text boxes — the same kinds of
changes you can make in the controls of any report.
Changing the page setup for labels
Unexpectedly, the report is only the size of a single label. You don’t see a
whole page full of labels. How does Access know how many labels to print
across a row? The Page Setup tab of the Ribbon contains this information.
If you specified the wrong Avery number in the Label Wizard (or if you have
labels that don’t have Avery numbers), you can change these settings.
With the report open in Design view, click the Columns button in the Page
Layout group on the Page Setup tab of the Ribbon to display the Page Setup
dialog box, with its Columns tab selected (as shown in Figure 2-11).
of the Page
on sheets of
You see the following settings:
✦ Number of Columns: How many columns of labels to print per page.
✦ Row Spacing: How much blank space to leave between one row of labels
and the next (usually zero, because Access includes this space in the