UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> spell check    
 
   
caleb
post Mar 1 2007, 12:23 PM
Post#1



Posts: 188
Joined: 4-September 06



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
Go to the top of the page
 
dashiellx2000
post Mar 1 2007, 12:31 PM
Post#2


UtterAccess VIP
Posts: 9,762
Joined: 11-March 05
From: Maryland


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.
Go to the top of the page
 
caleb
post Mar 1 2007, 12:43 PM
Post#3



Posts: 188
Joined: 4-September 06



thats perfect!! thansk so much
aleb
Go to the top of the page
 
dashiellx2000
post Mar 1 2007, 12:58 PM
Post#4


UtterAccess VIP
Posts: 9,762
Joined: 11-March 05
From: Maryland


You're welcome. Glad I could help.
Go to the top of the page
 
johan
post Oct 28 2008, 06:07 AM
Post#5



Posts: 965
Joined: 24-April 08
From: Riebeek Kasteel, Western Cape, South Africa


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
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 06:14 PM