Restrict text entry in textbox to JUST TEXT

**TheNewGuy** · 07-24-2009, 11:34 AM

I have a text box that I am using as the "search target" and to add to the database sheet. I need a way to make sure the user does not enter any spaces or funny characters that would make it more difficult to find the match when they want to search the database sheet at a later date.
For example if the user types in:

TEST123
it will get added to the database,

Then when they are trying to search the database they might accedentaly type in:
TEST 123

The SPACE will cause the database search macro to not find a match.
The search macro is not case sensitive, but is sensitive to any spaces..
Plus I think it will be easier for them to remember if it has to be ONLY Text and NO SPACES.
I Hope this makes sense, please ask if you need more clarification.
Thank you for your time,

**StephenR** · 07-24-2009, 11:45 AM

So you want to ensure no spaces or funny characters are allowed?

Define "funny characters".

**TheNewGuy** · 07-24-2009, 12:09 PM

Sorry,
"Funny Characters"= .,;;''!@#$%^&*(){[}]-_/?><.....stuff like that..

**JBeaucaire** · 07-24-2009, 12:17 PM

Here's a little UserDefinedFunction you can use as is in your code to run your textbox entry through, it will strip out all characters not alphabetic.

Or you can use the technique it shows directly within your own code.

Please Login or Register  to view this content.

When I put that into a textbox_change code, it seems to disallow anything except alphabet characters right from the user interface, very nice.

Please Login or Register  to view this content.

**StephenR** · 07-24-2009, 12:33 PM

Please Login or Register  to view this content.

**TheNewGuy** · 07-24-2009, 02:15 PM

I am not sure that is working, I tried it and it does not seem to do anything.
I was going to make my own userfrom to function as a error msg. Your code does not need me to Correct? And It is supposed to go into the Textbox1_change Correct? How is it supposed to work?