Altering the valus for autocorrect

  • Thread starter Thread starter Eric Kimball via AccessMonster.com
  • Start date Start date
E

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.
 
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.)
 
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
Click to expand...
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.
 
Back
Top