Is There a way to add microsoft spellcheck on some text feilds for my form.

[behnam]

Hi Guys,



Im just wondering if there is a way to add microsoft spellcheck to some of the text fields in my form. A spell checker identical to the one avaiable on word will be good.

Thanks for your time.

[ItsMe]

You can automate the Spelling tool found in the Quick Access Toolbar like this.
Application.RunCommand acCmdSpelling

I just ran a test on it and it seems to run through the entire recordset of the form. Not sure how you would restrict it to specific text.

[Missinglinq]

Replacing ControlToBeChecked with the actual name of your Control:

Private Sub ControlToBeChecked_Exit(Cancel As Integer)

With Me!ControlToBeChecked
   
  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

Linq ;0)>

[ItsMe]

There you go. DoCmd