Reports - No Longer Set

PreviewReport Function

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

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

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

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

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

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

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