Turn off auto-correct spelling

[Lynn_AccessUser]

Does anyone have the code to turn off auto-correct spelling. I know you can go into the db options and turn it off. The problem is that it seems to be machine specific rather than application specific. For example, I turned off the option and when I copied the db to another user's computer the auto-correct was enabled again.

I figure I would put the code on the open event property of the switchboard and when the user closed the db it would enable it again. If this is incorrect logic, please let me know.

Thanks!!

 

[Pat Hartman]

Try this article:
Setting Global Options Programmatically in Access 2000

 

[SforSoftware]

Hi,

I don't have the code you ask, but another option:
Controls (like textboxes) on your forms have an option "Allow Autocorrect" (or something like that, I'm not using an English version of Access), that you can set to No instead of Yes (Default).

Maybe that would do for you?

Saves code, but you have to set it one time for each textbox...

good luck,
Bert

PS. Pat, I looked for that, but couldn't find the AutoCorrect for Text?

 

[Lynn_AccessUser]

I couldn't find the global option either.

Yea, I was hoping I wouldn't have to set the property on every field on every form.

 

[SforSoftware]

But you can select all controls on a form and set the option for all that control in one time, so you've to set it one time for each form.

 

[Pat Hartman]

The article is specifically for A2K. If you are using a different version, the available options will be different. I could not find a similar article for AXP but I would use the technique suggested by the article. You can get the property name from the Options dialog.

If it turns out that there is no global option that controls this, write a sub that opens each form and loops through the controls setting the property. Run this against your forms periodically before you distribute the app to the users but don't give the user access to this code.