Textbox Control - City, State Zip Code

dbs_help

Registered User.
Local time
Yesterday, 18:12
Joined
Mar 10, 2007
Messages
18
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!
 
That would be:

Code:
=[City] & ", " & [State] & " " & [ZipCode]
 
Howzit

try...
Code:
=[City]&", "&[State]&' '&[ZipCode].
 
Last edited:
Thanks a lot for the quick and accurate reply. I am off the hook! :)
 

Users who are viewing this thread

Back
Top Bottom