Spell Check Help

[bladelock]

I have this code in the AfterUpdate in a TextBox set for a memo:

If Len(Me!casefacts & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If

everytime the spell check executs, it check the whole form. How can I get it
to just check that one textbox and not everything else.

 

[Marshall Barton]

I have this code in the AfterUpdate in a TextBox set for a memo:

If Len(Me!casefacts & "") > 0 Then
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If

everytime the spell check executs, it check the whole form. How can I get it
to just check that one textbox and not everything else.

You need to select the text to be spell checked:

If Len(Me!casefacts & "") > 0 Then
Me!casefacts.SelStart = 0
Me!casefacts.SelLength = Len(Me!casefacts)
DoCmd.RunCommand acCmdSpelling
Else
Exit Sub
End If

 

[Gina Whipp]

bladelock,

I just answered this post under forms. Please try not to multipost, cross
post instead.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm