report problems with City, State, Zip fields

S

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
 
R

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
 
Top