trim spaces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I trim spaces between fields in a report? One field (section) can be
anywhere from 1-5 characters long. I want the following field (section
suffix) to be immediately after and not several spaces over depending on how
long the first field (section) is. I know there is some kind of code that
eliminates empty spaces but I don't know the code or where to put it.
 
Carol
Use "concatenation". For ex. given a FirstName and LastName field...
Bob Anderson
Create an unbound text control and name it FullName. (never use the name
of any of the fields)
Give it a ControlSource of
=[FirstName] & " " & [LastName]
yields...
Bob Anderson

Or another common use is...
=[LastName] & ", " & [First Name]
yields...
Anderson, Bob
hth
Al Camp
 
Back
Top