Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Forms _ spell check

Posted by: caleb Mar 1 2007, 12:23 PM

so i have a memo box that i am running RunCommand acCmdSpelling
in the afterupdate event. however...the spell checker just keeps going....and continues through the rest of the records.
how can i just get it to check this record and this field.

Posted by: dashiellx2000 Mar 1 2007, 12:31 PM

Use the following code:

DoCmd.SetWarnings False
With Me.ControlName
  .SelStart = 0    
  .SelLength = Len(MeControlName)
End With
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True


Posted by: caleb Mar 1 2007, 12:43 PM

thats perfect!! thansk so much

Posted by: dashiellx2000 Mar 1 2007, 12:58 PM

You're welcome. Glad I could help.

Posted by: johan Oct 28 2008, 06:07 AM

Hi William
Thanks for this nifty code but i do get an error msg when runnng RunCommand acCmdSpelling in the afterudate event when i try change the spelling so that it is correct
rror msg
The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing DB from saving the data in the field