My PITA customer would like for me to show the City then a comma then the State. Since the City field data is of varying length, I’m having a problem putting the comma exactly where the city name ends. Any ideas? Thanks!
Gingerly (BOB member since 2011-03-24)
Formula: {City Field}+", "+{State Field} or you can the fields in a text box ({City Field}, {State Field} ).
kevlray 
(BOB member since 2010-06-23)
Thank you. Is there also a way to keep the spacing constant between the City field and the State field so that Fresno, CA would look like
Fresno, CA
and San Francisco, CA would look like
San Francisco, CA
as opposed to Fresno looking like
Fresno, CA
Gingerly (BOB member since 2011-03-24)
Huh?
Fresno, CA looks the same in both places. Also the examples I gave you should be consistent on the spacing between City and State.
Hailing from Visalia 
kevlray (BOB member since 2010-06-23)