Hello,

How do I get rid of trailing spaces in a string??

I have strings called strName and strSurname, which are populated by fields from a table.

The strName however has trailing spaces which I want to get rid of.

EG. I want to display the name & surname on a msgbox..

msgbox strname & " " & strSurname

the result must be something like.. "John Cooper" - without any spaces (except the one I specified) between the name & surname.

Thanks