Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

746

In addition to these properties, be sure to take note of the New Row or Col property for the

CompanyName Header section (see Figure 20.38). The values for New Row or Col are None,

Before Section, After Section, Before & After. You use New Row or Col to force Access to (for

example) start a new column immediately after a group footer or detail section has printed (see

Figure 20.39). Depending on your reports and their data, New Row or Col may provide you with

the flexibility necessary to make reports more readable.

FIGURE 20.38

Headers (and Footers) have properties that can be used to control actions when the grouping value changes.

FIGURE 20.39

New Row or Col forces Access to start a column before or after a section.