spell chekcing

[Lanason]

I have added:-

    DoCmd.RunCommand acCmdSpelling

after updating a memo field - if there is a spelling mistake then the box pops up for the corrections.
However is there a way of supressing the "spelling complete" message if the spelling is OK?

 

[Orthodox Dave]

Try setting warnings:

DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

I haven't tested this but in another thread on the pcreview site, this was found to allow the spelling corrections to show, but suppressed the "Spell Check Complete" popup.

Hope that helps

 

[Lanason]

works perfectly thank you