Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

744

FIGURE 20.35

Only a few changes are needed to produce snaking columns.

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 speci-

fied 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.37 clearly demonstrates the effect of changing the report to a snaking two-column lay-

out. Before the change, this report required 11 pages to print all the data. After this change, only

seven pages are required.

FIGURE 20.36

The wrong Column Layout setting can be very confusing!