All,
I have a dilemma with Auto Correct in MS Access (using 2010, but I assume this will be present in all versions).
I currently have the Auto Correct Feature, "Correct 2 capitalized first letters" turned on. Great feature.
However, I also have a custom login form that allows users to enter a user name and password. If the user's password has 2 capital letters (i.e. "GUnner") Access keeps correcting the text thereby disallowing the user to log in. While Access is functioning properly, I'm wondering if there is a way to get around this for just this one field ([txtPassword]) on this one form ([frmLogIn]).
I'm sure I can get around this by setting a module-level variable in the BeforeUpdate() event to allow the user to login but this seems to be skirting the issue - I figured I'd at least post the question.
Kind Regards and happy holidays to the Bytes community.
Gunner