>Thanks Vlad. That sounds reasonable. Maybe I could build in a "slapping mechanism" that smacks the user in the face when they press the single quote more than once in a field...rrrrrmaybe not. some of my users would get beat up pretty bad :)
>
>Thanks for suggestion.
>
>John.

Just let them enter the quotes, then take em out... no need to tell the user.. the really aren't entering anything wrong... Also, I belive you can create an input mask that only allows for characters and no punctuation.

But, getting the quotes out of your 6 text boxes is as easy as...

txtBox1.value = trans(txtBox1.value, "'", "")

repeat for other 5 text boxes.

BOb