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.
aleb

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

Use the following code:
!--c1-->

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

HTH.

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

thats perfect!! thansk so much
aleb

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