Others

Fix the Microsoft Access #Name? Error in Forms and Reports

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

Identify and fix the cause of #Name? appearing in Microsoft Access forms or reports.

Product
Microsoft Access
Device & OS
not provided
Scenario
A user opens a form or report expecting to see saved data.
Observed behavior
One or more controls display #Name? instead of the expected data.
Before you start

Identify whether #Name? appears in a table datasheet, query, form, or report, and note the affected field or control. If you use a split database, check whether the back-end file has recently moved.

Solution 1Recommended

Correct the control source and underlying fields

Use this method when #Name? appears in a form or report control.

1
Open the object in Design View

In the Navigation Pane, right-click the affected form or report and select Design View.

2
Inspect the control source

Select the control displaying #Name?, open the Property Sheet, and check Control Source on the Data tab. Note the field name or expression it references.

3
Check the record source

Select the form or report using the selector at the upper-left of the design surface. On the Property Sheet's Data tab, inspect Record Source and open its table or query to verify that the referenced field is included and spelled correctly.

4
Correct and test

Update the control's Control Source or add the missing field to the underlying query. Save the object, then switch to Form View or Report View to check the result.

Correct the control source and underlying fields
Check expressions too: If Control Source contains an expression, check that its field and control references use the correct names and that the expression syntax is valid.
Free Microsoft Office alternative

Work with exported Access data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet data. Export suitable Access data to Excel format to move it into WPS Spreadsheets; WPS does not repair Access databases or replace Access forms and reports.

Review and edit exported Access data in spreadsheetsOpen and save Microsoft Excel XLSX filesUse a familiar interface for common spreadsheet tasksMove spreadsheet data into a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does an Access text box show #Name? instead of a field value?

Access may be unable to resolve the text box's Control Source. In Design View, select the text box and check Property Sheet > Data > Control Source, then verify that the named field exists in the form or report's Record Source.

What if the field exists in a table but not in the form's query?

Open the query used as the form's Record Source and add the field to its output. Save the query, then reopen the form and check that the control uses the field's correct name.

How do I reconnect a moved Access back-end database?

Open the front-end database, go to External Data > Linked Table Manager, select the affected tables, and use the refresh or relink option to point them to the back-end file's current location.

Can WPS Office fix an Access #Name? error?

No. Check the control source, query fields, and table links in Microsoft Access. WPS Spreadsheets can work with data exported to an Excel file, but it does not repair Access forms or reports.