combining text in a report field?

  • Thread starter Thread starter Linn Kubler
  • Start date Start date
L

Linn Kubler

Hi,

I'm relatively new to Access, using Access 2000. I have a simple table with
a few fields. The two fields in question are fname and lname, both text.

I'm creating a report and I want to concatenate the fname and lname into one
field I'm calling "name".

I added a text box to my report and typed the following in it: =fname &
lname. (that gets translated to: =[fname]&[lname].

When I preview the report I get "#error" in that field.

Any suggestions? Am I doing something wrong in my syntax? If I simply
enter lname or fname it works fine but it doesn't like combining them.
Help!!

Thanks in advance,
Linn
 
The name of your text box is probably fname or lname. Change it to
txtFullName and the change the expression to:
=fname & " " & lname
 
Back
Top