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

  • Thread starter Thread starter merobins
  • Start date Start date
M

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,
 
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,
Click to expand...

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

=[First Name] & " " & [Last Name]
 
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
 
Thanks worked like a charm!

fredg said:
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,
Click to expand...

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

=[First Name] & " " & [Last Name]
Click to expand...
 
Thanks worked like a charm!

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

Damon

merobins said:
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,
Click to expand...
Click to expand...
 
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.

Jeff Boyce said:
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 said:
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,
Click to expand...
Click to expand...
 
Back
Top