Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

745

FIGURE 20.37

Snaking multiple columns conserve page space and provide more information at a glance.

You may be wondering about the other print options in the Page Setup dialog box (refer to Figure

20.35). Here is a short description of each of the relevant settings in the Layout tab of the Page

Setup dialog box:

l Number of Columns: Specifies the number of columns in the report. You should be

aware that Number of Columns affects only the Detail section, Group Header section, and

Group Footer section of the report. The Page Header section and Page Footer section are

not duplicated for each column. When designing a multi-column report, you must keep

the width of the design area narrow enough to fit on the page when multiplied by the

number of columns you’ve selected. Most often, printing a report in landscape mode helps

the width required for more than one column in a report.

l (^) Row Spacing: Additional vertical space allowed for each detail item. Use this setting if
you need to force more space between detail items than the report’s design allows.
l (^) Column Spacing: Additional horizontal space allowed per column. Use this setting if you
need to force more space between columns in the report than the design allows.
l (^) Item Size – Same as Detail: The column width and detail height will be the same as on
the report in Design view. This property is useful when you need to fine-tune the column
placement on a report (for example, when printing the data onto preprinted forms).
Making adjustments to the report’s design will directly influence how the columns print
on paper.
l Column Size – Width and Height: The width and height of a column. These options are
handy when printing onto preprinted forms to ensure that the data falls where you want it to.
l Column Layout: How the items are to be printed: either Across, Then Down or Down,
Then Across.