Textbox Control - City, State Zip Code

[dbs_help]

I am trying to add a textbox to my form that will show the string --- City, State ZipCode. I am using the expression builder and cannot seem to get what I want. I am using =[City],&' '&[State]&' '&[ZipCode]. The error message states that I have improper syntax. I am using XP Access.

Thanks in advance for any help!

 

[boblarson]

That would be:

=[City] & ", " & [State] & " " & [ZipCode]

 

[Kiwiman]

Howzit

try...

=[City]&", "&[State]&' '&[ZipCode].

 

[dbs_help]

Thanks a lot for the quick and accurate reply. I am off the hook!