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

Welcome Guest ( Log In | Register )

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

UtterAccess Addict
Posts: 188
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.

caleb
Go to the top of the page
 
+
dashiellx2000
post Mar 1 2007, 12:31 PM
Post #2

UtterAccess VIP
Posts: 9,209
From: Maryland
Use the following code:

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

UtterAccess Addict
Posts: 188
thats perfect!! thansk so much

caleb
Go to the top of the page
 
+
dashiellx2000
post Mar 1 2007, 12:58 PM
Post #4

UtterAccess VIP
Posts: 9,209
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

UtterAccess Guru
Posts: 640
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

error 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
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 01:40 PM