Combine City, State, Zip into one display field?
I have a database that has 3 Edit Boxes for City / State / Zip
In my layout I put all the boxes next to each other all left justify. Because the length of the City name can be short or long, there can be a long gap between the City and State. For Example:
Ord NE 68862
Kearney NE 68845
Scottsbluff NE 69361
Is there a way in my layout to combine these so it would display like:
Ord, NE 68862
Kearney, NE 68845
Scottsbluff, NE 69361
Thank you for any help...