Turn off Auto Spell check in forms

[wjburke2]

I have a form with a combo box used to select three character product codes. WOH, TEH, THE, IMA.... When the user types WOH Access automatically changes it to WHO, TEH changes to THE. Of course the user wants WOH or TEH. I have been asked to shut off the auto spell checker on this form and others where there are combo box’s that look up product codes. It seems to only happen when the hit Enter or TAB they can still select by clicking on the desired product. If I have to shut it off for the whole application thats ok.

 

[DCrake]

In the spell checker options make sure that Ignore upper case characters it ticked.

 

[wjburke2]

Thanks, I have MSA2010 I found it under "More Comands" "Proofing". This worked with my copy. When copied the applicatin to computers with Access Runtime it did not transder over. I was able to have then click the lighting bolt and deselect the correct as I type option. Hopefuly this will work and they can do this on all the forms. If any body has a VBA or possible way to make this apply to the distributed DB that would be great.

 

[boblarson]

And by the way that isn't spell check that is AutoCorrect Options under TOOLS. If you want it off for other people you will have to code in setting those options and unfortunately I do not know what that code is.

The other option is to have people go into their AutoCorrect Options and remove those abbreviations from the list. But it is a PER COMPUTER setting.

 

[missinglinq]

As Bob said, this is something that has to be done on each user's machine, and changing a user's Access settings, like changing a user's Systems Settings, is probably something that should really be done by the user.

The problem is that you're actually changing these things for MS Office, not MS Access! If you set WHO to be corrected to WOH, or THE to be corrected to TEH, when your users use MS Word to create a document, it's going to make the same corrections!

A document full of misspelled simple words like the and who could be quite embarrassing!

Linq ;0)>

 

[Kees_B]

I ran into the same problem in Access 2010 today. The solution is easy and quite logical. It's a setting (Allow Autocorrect) in the fields properties (Other tab). Set it to "no" and WOH stays WOH in stead of being autocorrected to WHO.

No need to do it on every machine. It's part of the form design, and therefore it should work in the runtime also. But I didn't try that.

Kees