Spell Checker Events

[Michael]

Does anyone know whether there is an event that can be
captured after a Spelling Check is complete - I need to
prompt the user to save any changes that have occurred.

I have several fields on a form and by using the Key Down
Event can determine if changes have occurred but this
doesn't work with the Spell Checker.

 

[Tony C]

I don't think it is possible to "capture" spell checking
events in the way you are wanting to do here. However
there may be another way: -

1. Create a Module.
2. Add function "SpellCheckControl" to the Module: -

Function SpellCheckControl()
DoCmd.RunCommand acCmdSpelling
<PUT YOUR PROMPTS IN HERE>
<ENTER FORM-SPECIFIC SAVE CODE HERE>
End Function

3. Save and close the Module.

4. Next you need to create a Macro "DoSpellCheck" that
runs the Function you have just created by using "RunCode".

5. Finally you need to customise your Toolbars so that
the Buttons performing the Spell Check run the
Macro "DoSpellCheck".

NOTE

For the Module you may need to determine whether the
current Object is a Form or not. If it is a Form then do
the prompts etc, otherwise do not do the prompts.

Final bit: -

Changes to records should be saved automatically, if this
is not happening then you may have a problem somewhere...

HTH

Tony C.