Reports - No Longer Set

Never Forget to Set Your Report Caption Again

With this trick, it's nearly impossible to forget to set your report's Caption property in Microsoft Access.

Detect if an Access Report is in Preview Mode, Report Mode, or Being Sent to the Printer

How do you know if a user is viewing a report on screen or if they sent it to the printer? With this simple technique from Access MVP, Karl Donaubauer.

Forms

The Reason MS Access Forms and Reports are Limited to 22 Inches

With today's large monitors, many Access developers have bumped into the 22" maximum form width. But do you know why it's not 21" or 23"?

Reports

Using Temp Tables as Report Record Sources

If you're having trouble building a query to run a complex report, you may be better off populating a temp table and using that as your report's record source.

Reports

Access Shape Drawing Reference

With a bit of creativity, you can draw just about anything on an Access report. Everything you need to know is in Crystal Long's definitive guide.

Code Library

Show a Friendly Message When a Report Has No Data

A handy function you can call from an Access report's Property Sheet to gracefully inform the user when their report has no data to display.

Reports

PreviewReport Function

This custom function is the simplest and safest way to preview reports in any Microsoft Access application.

Reports

Future Compatibility

Use this trick to support future functionality while still getting your code to compile in older versions of Access.

Reports

Avoid the Cascading Maximize

Prevent a full screen report from forcing the calling form to be maximized with this clever workaround.

Reports

The 'OpenReport' Action Was Canceled

Does it annoy you that using the Report NoData event as Codd intended results in a runtime error? Because it annoys me.

Reports

OpenReport Shows Wrong Data

Calling DoCmd.OpenReport on a report that's already open will not update the filtering on the report. You have to close it first.

Reports

Previewing Reports

That sound of your printer warming up means you forgot the acViewPreview flag again. You're better off avoiding DoCmd.OpenReport entirely.

Reports

Report Annoyances

Five things I hate about the default behavior of DoCmd.OpenReport.