Create a Calculated Full Name Field in a Microsoft Access Form
Question details
Display a full name in an Access form by combining existing first- and last-name fields without storing a redundant value.

- 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.
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.
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.
In the Navigation Pane, right-click the form and select Design View.
On the Design tab, select Text Box and place it on the form. Leave it unbound rather than selecting a table field.
Select the new text box, open Property Sheet, and set its Control Source to =[FirstName] & " " & [LastName].
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.

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.

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.




