Combining two table values into one field...

[BrianExcel]

I have a textbox on an Access form.

The text box is supposed to contain both first and last name from the "Employees" table, but I can't figure out how to concatenate the fields in the text box.

If the table name is "Employees" and the two column names are "FirstName" and "LastName" how would I do this? I am trying to do it through the "Control Source" option within the "Properties" for the field...

Thanks!

 

[Phildaburn]

=trim(trim([employees].[firstname]) & " " & trim([employees].[lastname]))

Does this work?
Phil...

 

[BrianExcel]

Thanks Phil, but when I input that text it gives me a #Name? error in the field.

To be clear, the table is "Employees" (didn't include capitals last time) and the columns are titled "First Name" and "Last Name"

I made sure all capitals and spaces are correct, but I still get the same error...

 

[Phildaburn]

=trim(trim([employees].[first name]) & " " & trim([employees].[last name]))

Uppercase/lowercase won't make a difference in the expression. Apologies regarding the lack of the space in your name field. Perhaps a question I should have asked in the first place: is the form bound to the employees table or to another table?

Phil...

 

[BrianExcel]

Phil,

Sorry to be so bothersome...I am knowledgeable on Excel but still a beginner at Access. When I enter your text into the expression builder, the value in the field says "Unbound".

How do I change this to bound if I need to?

 

[boblarson]

1, the form needs to be bound to use what Phil has said.

2. the fields need to be part of the form's record source.

3. You don't need to use trim or the table name.

=[First Name] & " " & [Last Name]

However you can't have text boxes with the same name or else it will give you an error. So if you have a control on the form which has the same name as either of those fields, make sure to change it to like txtFirstName or txtLastName so they aren't the same.

 

[BrianExcel]

Thanks Bob. How do you do #'s 1 and 2 below? I am good with Office products but I need some remedial knowledge to begin with...

 

[boblarson]

You bind a table to the form by either selecting the table from the form's RECORD SOURCE property or by selecting a saved query or by creating your own query by clicking on the ellipsis(...) that appears next to the record source property when you put your mouse in it.

#2 should be handled by doing #1.