Problems with Spell Checker on Access forms

[Mark LaGrange]

Hello - I've got an Office/Access 97 application where I
provide buttons on forms to call the Spell Checker
("DoCmd.RunCommand acCmdSpelling").

Everything works great when checking the spelling on an
existing record.

But if the spell checker is called while adding a new
record, and the user accepts a correction suggestion:

Access saves the record when it changes the text
The AfterInsert event fires, executing that code
The spell checker is still going

Any suggestions?

Thanks

Mark

 

[Albert D. Kallal]

I would change the buttion code to:

me.refresh
DoCmd.RunCommand acCmdSpelling

The me.refrsh will force a disk write, and thus your event problem will go
away...