Problems with Spell Checker on Access forms

  • Thread starter Thread starter Mark LaGrange
  • Start date Start date
M

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

Any suggestions?

Thanks

Mark
 
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...
 
Back
Top