Others

Create a Calculated Full Name Field in a Microsoft Access Form

Natalie TaylorNatalie Taylor Nov 20, 2026 868 views

Question details

Display a full name in an Access form by combining existing first- and last-name fields without storing a redundant value.

Create a Calculated Full Name Field in a Microsoft Access Form
Product
Microsoft Access
Device & OS
not provided
Scenario
A form needs to show a full name derived from separate FirstName and LastName fields.
Observed behavior
Access may prompt for a value if it interprets a name in the expression as a missing field.
Before you start

Confirm that the form's record source includes the first- and last-name fields, and check their exact names. Replace FirstName and LastName in the expression with your actual field names if they differ.

Solution 1Recommended

Add an unbound calculated text box to the Access form

Use this method to display a full name without saving a duplicate field in the table.

1
Open the form in Design View

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

2
Add a text box

On the Design tab, select Text Box and place it on the form. Leave it unbound rather than selecting a table field.

3
Set the expression

Select the new text box, open Property Sheet, and set its Control Source to =[FirstName] & " " & [LastName].

4
Name and test the control

On the Property Sheet's Other tab, give the text box a distinct name, such as txtFullName. Save the form and switch to Form View to check the result.

Add an unbound calculated text box to the Access form
If Access still prompts for a value: Check the spelling of each field in the expression and verify that both fields are included in the form's Record Source. Also ensure the calculated text box does not share a name with either source field.
Free Microsoft Office alternative

Work with Office documents and spreadsheets in WPS Office

WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Office format support make it easy to move existing files. It does not replace Microsoft Access or fix Access form expressions.

Use spreadsheet formulas to combine first and last names in tabular dataOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXNavigate a familiar interface for documents, spreadsheets, and presentationsUse a free, lightweight suite for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access ask me to enter a parameter value?

Access may not recognize a field or control name in the expression. In Design View, check the spelling in the text box's Control Source and confirm that the form's Record Source includes both name fields.

Do I need to add a FullName field to my table?

No. If you only need to display the name, add an unbound form text box and set its Control Source to =[FirstName] & " " & [LastName].

Can I use the same expression in an Access report?

Yes. Open the report in Design View, add a text box, and enter the expression in its Control Source. The report's record source must include both name fields.

What if my fields have different names?

Use the actual field names inside the brackets in the Control Source expression. For example, use =[GivenName] & " " & [Surname] if those are the names in the form's record source.