Altering the valus for autocorrect

[Eric Kimball via AccessMonster.com]

Users in this database need to add and remove values spacific to their industry in the autocorrect feature of access. When this database is started it needs to programatically alter the autocorrect list. I do not know how to do this.

 

[John Nurick]

In Access 2003 it's Tools|Autocorrect Options. AFAIK earlier versions
are similar.

The autocorrect entries are shared with the other Office applications,
so they can also be set from Word or Excel. (Word autocorrect entries
that contain formatting are stored separately and are not shared.)

 

[John Nurick]

Sorry Eric, I didn't read properly the first time.

AFAIK Access doesn't allow useful programmatic access to the (shared
Office) Autocorrect options. Instead, use Automation to create an
instance of Excel and use the AutoCorrect object it exposes to
manipulate the entries (or if you're more familiar with the Word object
model, use Word.AutoCorrect).

Users in this database need to add and remove values spacific to

their industry in the autocorrect feature of access. When this database
is started it needs to programatically alter the autocorrect list. I do
not know how to do this.