Spell Check

[Guest]

I have added a button on my form to do a spell check, with this code behind it:

DoCmd.RunCommand acCmdSpelling

The problem is this will only spell check the text boxes in the parent form.
I need the code behind the built-in toolbar 'abc' icon, which will spell
check the text box controls in a subform having the focus.

 

[GrahamT]

Philwrote
I have added a button on my form to do a spell check, with this cod
behind it

DoCmd.RunCommand acCmdSpellin

The problem is this will only spell check the text boxes in th parent form.
I need the code behind the built-in toolbar 'abc' icon, which wil spell
check the text box controls in a subform having the focus

Hi Phil

It looks to me that, because your spell-check button is on your mai
form, when you click the button, the focus automatically moves bac
to the main form. Thus, the sub-form doesn't get a look in

It would be better to make a separate form and create a separat
module to contain the code that your spell-check button will run. Th
first thing the code will need to do is set the focus back to you
main form/sub-form. However, I personally consider the best thin
would be to create a (floating) toolbar and put a copy of th
spell-check button on it. This toolbar could then contain othe
controls you want to use, both built-in and those you desig
yourself

Simple, really

Have fun

Graham