Others

How to Fix the #Name? Error in an Access Calculated Control

Kushani NimanthikaKushani Nimanthika Nov 3, 2026 872 views

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.

How to Fix the #Name? Error in an Access Calculated Control
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.
Before you start

Verify that your form's underlying record source (table or query) actually contains the exact fields you are trying to reference in your calculation.

Solution 1Recommended

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.

1
Open form in Design View

Right-click your form in the navigation pane and select Design View.

2
Access the Property Sheet

Select the calculated textbox (e.g., txtName) displaying the error, right-click, and choose Properties to open the Property Sheet.

3
Update the Control Source

Locate the 'Control Source' property under the Data tab. Enter the expression: =[FirstName] & " " & [LastName]

4
Use ampersands instead of plus signs

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.

Correct the Control Source Expression and Verify Field Names
Use the Expression Builder: To prevent typing errors, click the ellipsis (...) next to the Control Source property to use the Expression Builder, which allows you to safely select valid field names directly from your record source.
Free Microsoft Office alternative

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. 1. Download the software: Visit the official WPS Office website to download the free suite for your operating system.
  2. 2. Install and launch: Run the lightweight installer and open WPS Spreadsheet to easily manage your data lists and tables.
  3. 3. Import existing files: Open your existing .xlsx or .csv data files directly in WPS Office with complete formatting compatibility.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Lightweight installation with incredibly fast startup speeds.Familiar user interface making migration completely effortless.Built-in advanced PDF editing and conversion tools at no extra cost.
microsoft office alternative - wps office

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.