Can I merge two fields from database in one cell on a form?

[merobins]

I set up "first name" in one field in my database and "last name" as a second
field in the same database. On my form I would like it to read "Tom Smith".
Can I merge two field from the same database in one cell on a form in Access?

Help,

 

[fredg]

I set up "first name" in one field in my database and "last name" as a second
field in the same database. On my form I would like it to read "Tom Smith".
Can I merge two field from the same database in one cell on a form in Access?

Help,

Use an unbound text control on the form.
Set it's control source to:

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

 

[Jeff Boyce]

Another approach besides those already offered would be to use a query as
the source for your form, rather than pointing it directly at the table. In
your query, you could create a new field something like:

NewField: [FirstName] & " " & [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[merobins]

Thanks worked like a charm!

I set up "first name" in one field in my database and "last name" as a second
field in the same database. On my form I would like it to read "Tom Smith".
Can I merge two field from the same database in one cell on a form in Access?

Help,

Use an unbound text control on the form.
Set it's control source to:

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

 

[merobins]

Thanks worked like a charm!

in control source of form's textbox, enter
=[firstname] & " " & [lastname]

Damon

I set up "first name" in one field in my database and "last name" as a
second
field in the same database. On my form I would like it to read "Tom
Smith".
Can I merge two field from the same database in one cell on a form in
Access?

Help,

 

[merobins]

Thanks for your help, I will try this one when I am not such a novice! This
service is terrific and I really appreciate your help.

Another approach besides those already offered would be to use a query as
the source for your form, rather than pointing it directly at the table. In
your query, you could create a new field something like:

NewField: [FirstName] & " " & [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I set up "first name" in one field in my database and "last name" as a
second
field in the same database. On my form I would like it to read "Tom
Smith".
Can I merge two field from the same database in one cell on a form in
Access?

Help,