report problems with City, State, Zip fields

[Sandy]

Anyone know how to get rid of the trailing spaces in a
report? For instance, I have City, State & Zip in the
text of a letter that I am running a report for and would
like to get rid of the trailing spaces in the City field.
Any ideas? I've tried TRIM([CITY]) and it didn't work
unless I'm putting it in the wrong place

 

[Ken Snell [MVP]]

See reply in reports newsgroup where you posted a similar question.

 

[Rick B]

You would need to put them in one unbound text field and put the following
in the source:

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


Rick B