FIGURE 20-33
The wrong Column Layout setting can be very confusing!.
As long as the Same as Detail check box is not checked, Access intelligently adjusts the Column
Spacing and other options to accommodate the number of items across that you??™ve specified for the
report. With Same as Detail checked, Access will force the columns to whatever width is specified
for the columns in Design view, which might mean that the number of columns specified in the
Number of Columns parameter won??™t fit on the page.
Figure 20-34 clearly demonstrates the effect of changing the report to a snaking two-column layout.
Before the change, this report required 11 pages to print all the data. After this change, only
seven pages are required.
680
More Advanced Access Techniques Part III
FIGURE 20-34
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-32). Here is a short description of each of the relevant settings in the Arrange tab of the Page
Setup dialog box:
n Number of Columns: Specifies the number of columns in the report.
Pages:
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335