Show Multiple fields in 1 text box?

[John]

Hi
I have done this befor but cannot remember how to do it.
I have 2 fields [FirstName] and [LastName]
How do I show both fields in 1 TextBox?

Kind Regards

John

 

[Steve]

Base your form or report on a query and put the following expression in a
blank field:
FullName:[FirstName] & " " & [LastName]
On your form or report set the cpntrol source property of the tectbox to
FullName.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[KARL DEWEY]

[FirstName] & " " & [LastName]

 

[fredg]

Hi
I have done this befor but cannot remember how to do it.
I have 2 fields [FirstName] and [LastName]
How do I show both fields in 1 TextBox?

Kind Regards

John

In your report, add an unbound text control.
Set it's control source to:
=[FirstName] & " " & [LastName]

 

[John]

Thanks Guys,

Regards

John