can't concatenate fields with label wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top