Microsoft Office Tutorials and References
In Depth Information
The rptCustomerMailingLabels report is a multiple-column report. The labels will be
printed in ascending order by zip code and then in ascending order by last name. The
first label will be printed in the upper-left corner on the first page, the second label will
be printed to its right, the third label will be printed under the first label, and so on. This
style of multiple-column report is the across-and-then-down layout. Instead, Sarah wants
the labels to print with the “down, then across” layout—the first label is printed, the sec-
ond label is printed under the first, and so on. After the bottom label in the first column
is printed, the next label is printed at the top of the second column. The “down, then
across” layout is also called newspaper-style columns ,or snaking columns .
To change the layout of the mailing label report:
1. Switch to Design view. The Detail section, the only section in the report, is sized for
a single label.
First, you’ll change the layout to snaking columns.
2. Click the Page Setup tab on the Ribbon, click the Page Setup button in the Page
Layout group, and then click the Columns tab. The Page Setup dialog box displays
the Columns options for the report. See Figure 7-43.
Column options in the Page Setup dialog box
specifies the number
of column sets
option to print labels
down the page
pre v iew of
option to print labels
across the page
When you select a label
using a manufacturer’s
name and product code,
the options in the Grid Set-
tings and Column Size sec-
tions are set for you
automatically based on
The Columns options in the Page Setup dialog box let you change the properties of
a multiple-column report. In the Grid Settings section, you specify the number of
column sets and the row and column spacing between the column sets. In the
Column Size section, you specify the width and height of each column set. In the
Column Layout section, you select between the “down, then across” and the
“across, then down” layouts.
You can now change the layout for the labels.
3. Click the Down, then Across option button, and then click the OK button.
You’ve finished the report changes, so you can now save and preview the report.
4. Save your report design changes, and then switch to Print Preview. The labels
appear in the snaking-columns layout.
You’ve finished all work on Sarah’s reports.