can't concatenate fields with label wizard

[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!

 

[Marshall Barton]

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.

Did you forget the = sign?

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