How to Concatenate LastName and FirstName into FullName

[kmurtha]

Hey Everyone, Happy New Year

I have a table with a FirstName and LastName field. I have now added a FullName field. Here are my questions

1. How can I update the data to concatenate First and Last Into Full?
2. How do I modify the data entry form to "Build" the FullName from the first and the Last, not allowing for editing of Full?

I don't want people to edit the FullName as this would screw up the other two fields.

Thanks for you help.

K.

 

[HomerJ]

I'm sure someone will offer a better solution than I, but here's my 2 cents. Depending on how you intend to use the FullName, you could try a couple of different things. One, you could create a query that includes your table as a recordsource and put the expression...

=[FirstName]&" "&[LastName]

in the Field row. You could then use this query as your recordsource for whatever requires the FullName field.

Another option if your intent is to use FullName on a report or form and you have your table as the record source of the report or form (or subform), you could use the above mentioned expression in a textbox and get the desired result.

If these don't accomplish what you are trying to do, please provide more details about what you are trying to achive.

 

[kmurtha]

Homer

This does exactly what I need it to do on the entry Form Great! Thanks!

Now how do I post this to the "Fullname" field in the table?

Thanks again

Kevin

 

[Norie]

Now how do I post this to the "Fullname" field in the table?

Why do you want to do that?

If you already have the first name and last name fields in the table this would just be replicating the data.

You can use the expression provided in queries, forms reports etc.