Spell checking ...

[Frank]

Hello!

When I click the "Spelling" menu item, Access checks all records ... not
just the one currenly displayed on a form ... in the case of a parent-child
linked sub-form it checks all records linked to the displayed parent.

I have the "Cycle" property of my form set to "Current Record".

I suppose I could put my own "Spelling" button next to a field which will
copy the field's contents into a field on another form, fire off
DoCmd.RunCommand acCmdSpelling, and then copy the checked text back to my
form. But how would I know when the spell check is finished? It would be a
bit clunky to have a "Close" button on the other form to close it after
copying the text back.

Any ideas?

Also, is it possible to determine when Access is spell checking? I have
code in my form's BeforUpdate event which prompts the user "This record has
been changed - Do you want to save the changes?" which I would like to stop
firing off when spelling is being checked.

I will appreciate any ideas.

Thanks in advance.

 

[Linq Adams via AccessMonster.com]

'This limits the SpellChecker to the one field in the current record. It
could be done off of a button (by setting the focus back to the field in
question) but this eliminates the need of a button by using the Exit event
for the field.

Private Sub YourTextFieldName_Exit(Cancel As Integer)

With Me!YourTextFieldName

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