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:

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

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

Example of Report Comparison Differences

Module Differences Between Two Reports

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.