By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Auto Correct Dilemma (MS Access)

100+
P: 107
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
Dec 17 '13 #1

✓ answered by zmbd

Open form in design mode
Show the properties panel for the control in question
Click on [OTHER] tab
set the [Allow Auto Correct] property to "No"

save.
tada
-z
BTW: For anyone else, this is valid since ACC2003 thru ACC2010
This can also be set at run time.

Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,285
Open form in design mode
Show the properties panel for the control in question
Click on [OTHER] tab
set the [Allow Auto Correct] property to "No"

save.
tada
-z
BTW: For anyone else, this is valid since ACC2003 thru ACC2010
This can also be set at run time.
Dec 17 '13 #2

100+
P: 107
Once again, ZMBD --- Thank you!!

Happy holidays.

Gunner
Dec 17 '13 #3

100+
P: 107
Thanks again, ZMBD.

(sorry for the oversight /delay)

Gunner
Dec 18 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.