Spell check problem

[Cheryl]

I have Word documents that will be created from MS Access by way of the merge
functions. Once the new Word document has been created and I try to do a
spell check, I get the “Text marked with ‘Do not check spelling or grammar’â€
message. I know that when open Word normally, it is not set. I have seen
the responses by selecting all, Tools, Language, etc. but is there a way that
this can be done without user intervention. Can someone point me in a
direction to prevent this from happening to every document that is created
from the Access piece? Any suggestions are greatly appreciated.

 

[Robert M. Franz (RMF)]

Hello Cheryl

I have Word documents that will be created from MS Access by way of the merge
functions. Once the new Word document has been created and I try to do a
spell check, I get the “Text marked with ‘Do not check spelling or grammar’â€
message. I know that when open Word normally, it is not set. I have seen
the responses by selecting all, Tools, Language, etc. but is there a way that
this can be done without user intervention. Can someone point me in a
direction to prevent this from happening to every document that is created
from the Access piece? Any suggestions are greatly appreciated.

version of Word/Access?

I can only test in Word 2000 at the moment, but for "mailmerged"
Mergefields, I can confirm that "Do not check spelling or grammar" is
checked in a merged document.

This makes sense IMHO: generally, you would not want to spellcheck your
DB's contents (well, in an ideal world, at least ).

I'm pretty sure you can automate the deselection of the spelling
checkbox. Word 2002 brought MailMerge events, and that seems to be the
way to go. Check out Cindy Meister's MailMerge-FAQ at
http://homepage.swissonline.ch/cindymeister/ ("Mail merge in Word
2002/2003").

HTH
Robert