Others

How to Find Unused Fields in Access Queries, Forms, and Reports

Kushani Nimanthika Oct 10, 2026 868 views

Question details

Identify fields referenced by database objects before deleting potentially unused table columns.

How to Find Unused Fields in Microsoft Access Queries, Forms, and Reports

Product: Microsoft Access
Device & OS: not provided
Scenario: Database cleanup and table optimization
Observed behavior: Users need a safe method to trace field dependencies across queries, forms, reports, and code to avoid breaking functionality when removing columns.

Before you start

Before attempting to trace field dependencies, ensure that 'Track Name AutoCorrect Information' is enabled in your Access Options, but leave 'Perform Name AutoCorrect' disabled to prevent unintended automatic renaming.

Solution 1Recommended

Use Object Dependencies to Trace Fields

Utilize Access's native Dependency Walker to view relationships and locate which forms, reports, and queries rely on specific table fields.

The built-in Object Dependencies pane is the most direct way to trace references. Keep in mind that this feature does not inspect VBA code, so manual code review will still be necessary for complex databases.

Enable tracking

Navigate to File > Options > Current Database, and check the box for 'Track name AutoCorrect info'.

Select the object

In the Navigation Pane, click on the table or query containing the fields you want to investigate.

View dependencies

Go to the 'Database Tools' tab on the ribbon and click 'Object Dependencies'. Toggle between 'Objects that depend on me' and 'Objects that I depend on' to trace the references.

VBA Limitation: Dependency Walker does not inspect VBA code. You will need to review VBA modules separately to ensure fields aren't being referenced in backend scripts.

Solution 2

Run the Database Documenter

Generate detailed structural reports of your database objects to find specific field references and control sources.

Solution 3

Test by Prefixing Field Names

A practical, manual fallback method to verify if a field is still actively used before permanently deleting it.

Free Microsoft Office alternative

Need a Lightweight Suite for Documents and Spreadsheets?

While Microsoft Access handles complex relational databases, your daily document, spreadsheet, and presentation tasks can be easily managed with WPS Office. It provides a lightweight, fast, and completely free alternative to the Microsoft Office suite.

1. Download the installer: Visit the official WPS Office website and download the free installation package.
2. Install the software: Run the setup file and follow the on-screen prompts to install Writer, Spreadsheet, Presentation, and PDF tools.
3. Open your files: Instantly open your existing .docx, .xlsx, and .pptx files with full formatting compatibility.

Seamlessly open and edit Microsoft Word, Excel, and PowerPoint filesLightweight application that won't slow down your computerFamiliar ribbon interface requires zero learning curveBuilt-in PDF editing tools for complete document management

Frequently Asked Questions

Can the Access Object Dependencies tool find fields referenced in VBA?

No, the built-in Dependency Walker does not inspect VBA code. You must manually review your VBA modules or use specialized third-party tools to find fields referenced strictly in code.

Why should I disable 'Perform Name AutoCorrect'?

While 'Track Name AutoCorrect Info' is necessary for viewing dependencies, 'Perform Name AutoCorrect' will automatically rename references if you rename a field. In complex databases, this automatic renaming can cause unintended behavior and break query logic.

Are there third-party tools to help find unused Access fields?

Yes, advanced third-party analyzers like FMS Total Access Analyzer or Crystal Long's Database Analyzer can perform deeper inspections across all database objects, including VBA, to identify unused fields accurately.

Can I use VBA to check form control sources?

Yes, you can write custom VBA code that loops through the Controls collection of your forms and reports to read the ControlSource property, helping identify which fields are actively bound to controls.

Office Quick Solutions