Show Multiple fields in 1 text box?

J

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
 
S

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
[email protected]
 
F

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

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