How to Fix the #Name? Error in an Access Calculated Control
Question details
The user needs to resolve a #Name? error that appears in a calculated textbox intended to combine first and last name fields on a database form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Setting up a calculated control on an Access form to combine text fields into a single display value.
- Observed behavior
- The calculated textbox displays a #Name? error instead of correctly concatenating and showing the combined text values.
Verify that your form's underlying record source (table or query) actually contains the exact fields you are trying to reference in your calculation.
Correct the Control Source Expression and Verify Field Names
Fix syntax issues in the Control Source and ensure the correct text concatenation operator is used to avoid Null value errors.
The #Name? error typically occurs when Access cannot identify the field referenced in the control source expression, or when the syntax used for concatenation is improperly formatted.
Right-click your form in the navigation pane and select Design View.
Select the calculated textbox (e.g., txtName) displaying the error, right-click, and choose Properties to open the Property Sheet.
Locate the 'Control Source' property under the Data tab. Enter the expression: =[FirstName] & " " & [LastName]
Ensure you are using the ampersand (&) for text concatenation. Using the plus sign (+) can cause the entire expression to return an error or a Null value if either the first or last name is missing.

Rename Controls to Prevent Circular References
Avoid giving a calculated control the exact same name as an existing field in your database, which creates conflicts.
Recreate the Corrupted Form Controls
Delete and replace the problematic controls if the form elements have become corrupted.
Discover WPS Office for Your Daily Document Needs
While Microsoft Access handles complex database management, WPS Office is the ideal free, lightweight, and highly compatible alternative for all your word processing, spreadsheet, and presentation tasks. Enjoy a familiar interface and seamless document migration without the heavy subscription fees.
- 1. Download the software: Visit the official WPS Office website to download the free suite for your operating system.
- 2. Install and launch: Run the lightweight installer and open WPS Spreadsheet to easily manage your data lists and tables.
- 3. Import existing files: Open your existing .xlsx or .csv data files directly in WPS Office with complete formatting compatibility.

Frequently Asked Questions
Why does Access show a #Name? error when my field names are spelled correctly?
This commonly happens when the calculated control shares the exact same name as one of the database fields used in your expression, which creates a circular reference. You can fix this by changing the Name property of the control to something unique.
What is the difference between using a plus sign (+) and an ampersand (&) for text concatenation in Access?
The ampersand (&) is specifically designed for concatenating text and will gracefully ignore Null (empty) values. The plus sign (+) acts as a mathematical operator; if any field in a plus-sign concatenation is Null, the entire combined result becomes Null, which can trigger errors.
How do I use the Expression Builder in Access?
Open the Property Sheet for your control, navigate to the Control Source property, and click the ellipsis (...) button on the right side. This opens the Expression Builder window, where you can safely browse and double-click valid fields from your form's record source to build your formula without typing errors.




