By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

MS Access Spell Check

100+
P: 134
I have seen posting on Spell check problem, but seem like not solution. Therefore I post this question again.

How can I spell check on one record and on one field such as Notes in my Form. MS Access seem to spell check on all my records and other fields.
Dec 25 '06 #1
Share this Question
Share on Google+
4 Replies


missinglinq
Expert 2.5K+
P: 3,532
Sorry to say I can't remember where I got this from, but it'll do the job:

Expand|Select|Wrap|Line Numbers
  1. Private Sub SpellCheck_Click()
  2. With Me!Notes
  3.     .SetFocus
  4.    If Len(.Value) > 0 Then
  5.       DoCmd.SetWarnings False
  6.      .SelStart = 1
  7.      .SelLength = Len(.Value)
  8.      DoCmd.RunCommand acCmdSpelling
  9.     .SelLength = 0
  10.     DoCmd.SetWarnings True
  11.   End If
  12. End With
  13. End Sub
Dec 25 '06 #2

100+
P: 134
Sorry to say I can't remember where I got this from, but it'll do the job:

Expand|Select|Wrap|Line Numbers
  1. Private Sub SpellCheck_Click()
  2. With Me!Notes
  3.     .SetFocus
  4.    If Len(.Value) > 0 Then
  5.       DoCmd.SetWarnings False
  6.      .SelStart = 1
  7.      .SelLength = Len(.Value)
  8.      DoCmd.RunCommand acCmdSpelling
  9.     .SelLength = 0
  10.     DoCmd.SetWarnings True
  11.   End If
  12. End With
  13. End Sub
Wow ! it Work, thank you so much for your fast response
Dec 25 '06 #3

missinglinq
Expert 2.5K+
P: 3,532
That's why we're here!

Happy Holidays!
Dec 25 '06 #4

NeoPa
Expert Mod 15k+
P: 31,616
Nice one ML - Good answer :)
Dec 30 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.