two input masks?

[JoshC]

I have a form that allows employees to select their name from a list, and then they must enter a correct password into a text box before they are allowed to continue. It works great, except that it is case sensitive, and that will confuse our employees... I guarantee. I obviously must have the Password input mask, and if I could also have a >AAAaaaaaaa input mask, then case wouldn't be a problem. I could use the SendKeys statement to hit the Caps Lock key On Enter and On Exit of the text box, but if one of the employees were to turn on the Caps Lock manually, nobody's password would work. There has to be a way around this, and (like always) I'm sure it's some really simple bit of VBA that I have yet to learn. Please let me know if you have any ideas!
Thanks!
Josh C.

 

[dneufarth]

You might try the lcase/ucase functions to convert the user's entry into the appropriate case before doing the lookup or query.

Dave

 

[JoshC]

thanks! I'll give that a shot