Thanks for taking the time to read my post.
A user asked me to provide her with spell check on a specific field in a form. The name of the control is StatusNotes. So on the AfterUpdate event of that control I used the following code:
Private Sub StatusNotes_AfterUpdate()
On Error Resume Next
If Len(Me!StatusNotes & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
The spell check works as expected but if it finds a misspelled word, and you click either the "Change" or "Ignore" options and it's the last misspelled word in that field it then cycles to the next record and finds any misspelled word in whatever field of that record. Can someone help to limit the spell check to work only on the specified field and not cycle to the next record?
Thanks
A user asked me to provide her with spell check on a specific field in a form. The name of the control is StatusNotes. So on the AfterUpdate event of that control I used the following code:
Private Sub StatusNotes_AfterUpdate()
On Error Resume Next
If Len(Me!StatusNotes & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
The spell check works as expected but if it finds a misspelled word, and you click either the "Change" or "Ignore" options and it's the last misspelled word in that field it then cycles to the next record and finds any misspelled word in whatever field of that record. Can someone help to limit the spell check to work only on the specified field and not cycle to the next record?
Thanks