>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only