MS Access Spell Check

jamesnkk

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.

missinglinq

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

Expand|Select|Wrap|Line Numbers

 Private Sub SpellCheck_Click()

With Me!Notes

    .SetFocus

   If Len(.Value) > 0 Then

      DoCmd.SetWarnings False

     .SelStart = 1

     .SelLength = Len(.Value)

     DoCmd.RunCommand acCmdSpelling

    .SelLength = 0

    DoCmd.SetWarnings True

  End If

End With

End Sub

jamesnkk

Quote:

Originally Posted by missinglinq

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

Expand|Select|Wrap|Line Numbers

 Private Sub SpellCheck_Click()

With Me!Notes

    .SetFocus

   If Len(.Value) > 0 Then

      DoCmd.SetWarnings False

     .SelStart = 1

     .SelLength = Len(.Value)

     DoCmd.RunCommand acCmdSpelling

    .SelLength = 0

    DoCmd.SetWarnings True

  End If

End With

End Sub

Wow ! it Work, thank you so much for your fast response

missinglinq

That's why we're here!

Happy Holidays!

NeoPa

Nice one ML - Good answer :)

MS Access Spell Check

re: MS Access Spell Check

re: MS Access Spell Check

re: MS Access Spell Check

re: MS Access Spell Check

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about