Reports - No Longer Set

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.

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.