How Do I Invoke Spell Check from Within Access VBA

[Guest]

User wants to invoke spell check for fields within a table since data entry
spelling is variable. How do I do this from within VBA?
Earl Phillips
Volunteer Programmer
Harvesters Community Food Bank

 

[Steve Schapel]

Earl,

DoCmd.RunCommand acCmdSpelling

Note that this invokes the Office spell-ckecker, and relies on an Office
installation of the same version as the Access installation. Also note
that this code is often best run from a Command Button... if you use the
After Update event of a control or form or whatever, the spelling
checker runs even if there are no errors detected, which can be annoying.

 

[Guest]

This invokes Spell Check, but I was hoping to limit the check to contents of
the open form, not the entire database. Is there any way to have spellcheck
follow the tab order of the form and quit at the end?