How do you strip spaces out from a field value.

alltrim(thisform.myfiled.value).. the value is 'modem'

when I say..

myvar = alltrim(thisform.myfiled.value)

myvar is 'modem' but is has two more spaces in it.

should have 5 spaces, but it has 7 spaces.

what to do?