O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required