Ok, I found this code on the internnet.
Private Sub CompanyName_AfterUpdate()
'If the textbox contains data run the
'Spell Checker after data is entered.
If Len(Me!CompanyName & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
now... he're the rub,
it works great doing a spell check of the fields that I tab through, but on my main form it will try and spell check the WHOLE TABLE.
How do I customize this to keep the spell check only to the record I have selected and not try to spellcheck 5000 enteries?
I want to use this for people who are inputing data into new fields, or editing fields of records. I have another button set up elseware for a full check.
Private Sub CompanyName_AfterUpdate()
'If the textbox contains data run the
'Spell Checker after data is entered.
If Len(Me!CompanyName & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If
End Sub
now... he're the rub,
it works great doing a spell check of the fields that I tab through, but on my main form it will try and spell check the WHOLE TABLE.
How do I customize this to keep the spell check only to the record I have selected and not try to spellcheck 5000 enteries?
I want to use this for people who are inputing data into new fields, or editing fields of records. I have another button set up elseware for a full check.