trim spaces

[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.

 

[Al Camp]

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

 

[Guest]

Try the repace function

Replace(FieldName," ","")

 

[Guest]

Ignore my post, I miss understood the question

Try the repace function

Replace(FieldName," ","")