excluding characters input to a textbox

[Erkano Timenon]

I am trying to create a password entry textbox on a form.
I would like to not allow single quotes, double quotes, the pound sign, ... etc. but want to accept other printable characters. I want the value of the textbox to be used as a string.

How can I check for the invalid characters, ignore them or tell my user the character is not allowed, but continue to get entered characters until the user has finished entering a password?

[jimatqsi]

Here's one way to ignore them. In the AfterUpdate event of the password object you can add this VBA:

me.password_txt =replace(replace(replace(me.password_txt,"'",""),"#",""),chr(34),"")

That will eliminate single quote, double quote and # from the entered password.

You can also look at various ways to use the validation property of the textbox.

Jim

[twinnyfo]

Erkano Timenon,

Welcome to Bytes!

I would begin by attaching some code to the OnKeyPress Event of the Text Box control. That code would evaluate the last key press of the User, then truncate the string by one character if it was an invalid character. If it was a valid character, there would be no action and the user could continue to enter text.

Play around with it and if you come up with some road blocks in your code, let us know and we will try to help you walk through it.

[jimatqsi]

I like that solution, twinnyto. It's also real good stuff for a newbie to learn.

[NeoPa]

Be very careful how you handle special characters :- For instance the cursor movement keys or the (destructive) backspace key.