can't concatenate fields with label wizard

D

daisyn

Hi. I'm using Access 2002. When I try to list 2-3 fields on 1 line with
label wizard (for example, city & state & zip, Washington DC 20008), I get an
"enter parameter value" dialog box and "error" in that line of the label. I
am able to concatenate the fields in a query, though, and then include the
result in the label.

Appreciate you help!
 
M

Marshall Barton

daisyn said:
Hi. I'm using Access 2002. When I try to list 2-3 fields on 1 line with
label wizard (for example, city & state & zip, Washington DC 20008), I get an
"enter parameter value" dialog box and "error" in that line of the label. I
am able to concatenate the fields in a query, though, and then include the
result in the label.
Click to expand...


Did you forget the = sign?

=City & ", " & State & " " & Zip
 
Top