Spell checking current record

[jamccarley]

I have added a spell check to a database using

DoCmd.RunCommand acCmdSpelling

Which works, I just want it to spell check the current record, not the whole
database. Is that possible?

 

[Dirk Goldgar]

I have added a spell check to a database using

DoCmd.RunCommand acCmdSpelling

Which works, I just want it to spell check the current record, not the
whole
database. Is that possible?

IIRC, if you select the record first, it only spell-checks that record. So
try:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSpelling

 

[jamccarley]

That worked perfectly, you the man.

Thanks

IIRC, if you select the record first, it only spell-checks that record. So
try:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSpelling


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)