F. Scott Barker's Microsoft® Access 2000 Power Programming

FORMATTING REPORTS DYNAMICALLY

Sometimes you will want to apply formatting, show or hide controls, or perform calculations at runtime section by section or control by control in a report. Fortunately, Access gives you a great deal of flexibility for adding these features to your applications.

In the first example, colors are alternated for the rows in a report's Detail section. This feature can make it easier for users to read across long rows, and it's a quick way to add a professional touch to your reports.

Looking at the DynamicFormattingExample Report

The simple DynamicFormattingExample report, in the Chap11.mdb database in the Examples\Chap11 folder on the accompanying CD-ROM, lists and counts orders by customers. Figure 11.36 shows the ...