Compare and Find Microsoft Access Report Differences

Total Access Detective performs detailed comparisons between two reports to reveal exactly what's different. Compare two reports in one database or identically named reports in two databases.

Total Access Detective makes it easy to find changes to your reports:

  • Report Properties (recordsource, caption, description, etc.)
  • Controls
    • Control Names on one report but not on the other
    • Control Type and other properties for identically named controls
  • Section Properties
    • Report Header and Footer Properties
    • Page Header and Footer Properties
    • Grouping section properties
    • Detail Properties
  • Embedded Macros at the report, section, and control levels
  • Module Code behind the report

Comparing Microsoft Access Reports

When comparing two reports, you can compare the object (report design) and/or module code:

Compare Microsoft Access form properties, modules, or both

Module comparison has the same options as comparing two standard modules.

Options for Comparing Microsoft Access Module Text

Here's more information on module comparison options.

Report Comparison Results

If you choose Object and Module, the results are displayed in a form with four tabs:

  • Object: property, control, and section differences
  • Module Differences:
    • Procedures that exist on one report and not on the other
    • Line by line comparison of identically named procedures
  • Identical Procedures: list of procedures with no changes
  • Embedded Macros: line by line comparison of embedded macros

Design Differences Between Two Reports

Difference between two Microsoft Access reports showing controls in one but not the other, property and section differences
Example of Report Comparison Differences

Module Differences Between Two Reports

Differences bewteen modules for code behind reports in Microsoft Access
Example of Module Code Behind Report Differences

For additional information on how Total Access Detective compares modules, visit Finding Microsoft Access Module Differences (VBA)

Reports for Report Differences

Reports are available for:

  • Report Design Differences
  • Embedded Macro Differences
  • Module Differences
  • Identical Procedures
  • Printouts of each report's entire module

Reports can be printed, previewed, opened in Report View, or exported to a variety of formats such as PDF, HTML, text, etc.

Total Access Detective Manual and CD

Microsoft Access 2016 Version is shipping!

New Features

New Version 15.5 for
Access 2013

New Version 14.5 for
Access 2010

New Version 12.9 for
Access 2007

Version 11.8 for
Access 2003

Versions 10.7 and 9.7 for
Access 2002 and 2000

Version 8 for
Access 97

View all FMS products for Microsoft Access All Our Microsoft Access Products


"Total Access Detective is well worth every penny, it will quickly pay for itself through savings in time and effort."

Tom Cryan, Denver Access User Group product review

Readers Choice Award
Best Debugging Tool

Detective Info

Why Detective?

Additional Info



Free Product Catalog from FMS