Compare and Find Microsoft Access Form Differences
Total Access Detective performs detailed comparisons between two forms to reveal exactly what's different. Compare two forms in one database or identically named forms in two databases (ACCDB, MDB, or ADP formats).
Total Access Detective makes it easy to find changes to your forms:
- Form Properties (recordsource, caption, views, description, etc.)
- Controls
- Control Names on one form but not on the other
- Control Type and other properties for identically named controls
- Section Properties
- Form Header and Footer Properties
- Page Header and Footer Properties
- Detail Properties
- Embedded Macros at the form, section, and control levels
- Module Code behind the form
When comparing two forms, you can compare the object (form design) and/or module code:
Module comparison has the same options as comparing two standard modules.
Here's more information on module comparison options.
MS Access Form Comparison Results
The results are displayed on up to five tabs:
- Object: property, control, and section differences
- Module Differences:
- Procedures that exist on one form and not on the other
- Line by line comparison of identically named procedures
- Identical Procedures: list of procedures with no changes
- Procedures with Differences: list of procedures with differences
- Embedded Macros: line by line comparison of embedded macros
Design Differences Between Two Forms
See controls, sections, and property differences between two forms.
Controls in One Form but Not the Other
Quickly filter to see the objects (controls and sections) that exist in one form but not the other. They may have been added, deleted, or renamed.
Differences between Module Code behind Forms
Compare the procedures by name (order in module doesn't matter), then line-by-line for identically named procedures.
Identical Procedures between Microsoft Access Form Modules
List of procedures with identical lines.
Procedures with Differences between Microsoft Access Form Modules
List of procedures that have module line differences.
Embedded Macro Differences between Access Forms
Line by line comparisons of embedded macros.
Reports are available for:
- Form Design Differences
- Module Differences
- Identical Procedures
- Printouts of each form's entire module
- Embedded Macro Differences
Microsoft Access 365/2024 Version is shipping!
New X.6 Versions for Access 2016, 2013 and 2010
New Version 12.9 for
Access 2007
Version 11.8 for
Access 2003
Reviews
"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
Best Debugging Tool
Detective Info
Why Detective?
Additional Info
