report problems with City, State, Zip fields

  • Thread starter Thread starter Sandy
  • Start date Start date
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
 
You would need to put them in one unbound text field and put the following
in the source:

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


Rick B
 
Back
Top