Reports HELP! My Access Report is Missing Information When my Users Run It Your Access report runs fine on your computer, but it's broken when an end user runs it. What gives?
Reports 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.
Reports 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.