Fix the Microsoft Access #Name? Error in Forms and Reports
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.
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.
Correct the control source and underlying fields
Use this method when #Name? appears in a form or report control.
In the Navigation Pane, right-click the affected form or report and select Design View.
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.
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.
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.

Relink tables in a split Access database
Use this method if the back-end database has moved or linked tables cannot be opened.
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.

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.




