Reports

Closing a report automatically if no data exists

A simple method using the OnNoData event.

Changing the zoom on a report depending on the number of pages

An easy method using the powerful DoCmd.RunCommand

Hiding the page header on the first page of a report

Chances are you won't want the report header and the page header on the first page; here's the easiest way I've found of hiding the latter on page one.

Alternating line colour in a report

How to alternate line colour for successive rows in a report.