Spell Check

[shart00]

In Access 2003, is there away to modify the below code to only check the current record?
DoCmd.SetWarnings False 'turn off system warning if spell check returns no error'
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True 'turn back on the system warnings'

It has been suggested to use auto correct, but it seems to be enabled and is not catching everything that spell check would. Therefore, I need to keep spell check active, but it checks the current record then goes back to record 1 and starts over.

Thank you for any suggestions.

 

[dotdavid]

Try;

DoCmd.SetWarnings False
DoCmd.RunCommand
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

That's what's written on other tek tips posts, and it seems to work in my databases.

 

[dotdavid]

Sorry where it says
DoCmd.RunCommand

it should say
DoCmd.RunCommand acCmdSelectRecord

Oops