Lowercase typing into textbox

[yeldos]

I have a form with the login and password textboxes. How to allow only lowercase typing into textbox? For example, even if a user has a caps lock turned on, the typing should be always lowercase.

[Micron]

You are concerned more about how the data looks, or how it's actually stored? You can us case functions (LCase, UCase) (lower,upper) on the form control and show it either way. I believe there is a PCase function as well, plus a strConv function. How they are used would determine if the data is stored with the desired case or just displayed. How it's stored shouldn't really matter.

I suppose you could use an input mask, but I can't recall ever using one myself. Too much hassle for users most of the time.

[moke123]

In addition to the functions Micron mentioned, There is also a StrComp() function, with a binary comparison, if you want the typed in password be required to match the case of the saved password.

[June7]

Access is not case sensitive by default. "A" = "a". Textbox format setting can force every character to display as lowercase. Set Format property with: < for lowercase, > for uppercase. However, the actual typed characters will be saved into field. Use VBA code with LCase() function to actually change the characters to be saved.