try

StrTran(This.Value, " ", "")

hope this helps

>Is there an easy and/or hard way to make sure that when the user enters a value in the textbox (on a form) that the value does not contain spaces. I can do an alltrim to leading and trailing, but it's the one's in the middle I need to make sure they don't do.
>
>thanks
>Kirk