Spellcheck cmd button for current record only

[Pamela]

I have a cmd button on my form to run spell check. Was given this original
code:
Private Sub Command108_Click()

DoCmd.RunCommand acCmdSpelling

End Sub

But that checks ALL records... then was told to add:
DoCmd.RunCommand acCmdSelectRecord
above the DoCmd.RunCommand acCmdSpelling line but when I test it by
misspelling simple words in the record, it doesn't find them - just states
Spell Check Complete.

Any ideas?

Thanks!
~Pamela

 

[Dirk Goldgar]

I have a cmd button on my form to run spell check. Was given this original
code:
Private Sub Command108_Click()

DoCmd.RunCommand acCmdSpelling

End Sub

But that checks ALL records... then was told to add:
DoCmd.RunCommand acCmdSelectRecord
above the DoCmd.RunCommand acCmdSpelling line but when I test it by
misspelling simple words in the record, it doesn't find them - just states
Spell Check Complete.

Any ideas?

Thanks!
~Pamela

So you have

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSpelling

? That works fine for me, at least in Access 2003 -- I haven't tried it in
Access 2007. When you run the spell-check for all records, does it flag
spelling errors that it ignores when you run it just for the current record?
Do the words you misspelled in your test fall into any of the categories
that your spell-check options might be set to ignore: upper case, words
with numbers, etc.?