Simple but stuck

M

myxmaster

I have placed the following in a textbox in the report footer
=[firstname] & [Last Name]. When I refer to it in the report header it
reads JohnSmith with no spacing. I have tried enclosing the "&" . How
do I make a space between the first and last name.
TIA
 
F

fredg

I have placed the following in a textbox in the report footer
=[firstname] & [Last Name]. When I refer to it in the report header it
reads JohnSmith with no spacing. I have tried enclosing the "&" . How
do I make a space between the first and last name.
TIA

=[FirstName] & " " & [LastName]
 
Top