Spellcheck cmd button for current record only

P

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
 
D

Dirk Goldgar

Pamela said:
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.?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top