Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2006

Tip: Looking for answers? Try searching our database.

Spell check fields from a data base

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jules - 07 Sep 2006 03:16 GMT
We have a custom data base application that merges with Word 2000 to produce
documents.  The documents contain fields that are populated from the databse
and converted to text when the data and documents are meged together.  Once a
document is produced, the Word spellcheck will not check any text that has
come from the fields in the database.  I have set up a macro to run when the
documents merge to try and rectify the spellcheck problem, however this only
results in the spellcheck checking the first incorrect word and then stating
that the spellcheck is complete even though we know there are further
mispelled words in the document.

The code for the macro is as follows:

   Selection.WholeStory
   Selection.LanguageID = wdEnglishAUS
   Selection.NoProofing = False
   Application.CheckLanguage = True

After the document merges, the macro runs automatically and then we run the
spellcheck manually with the result that only the first mispelled word is
checked.

Any suggestions?
thanks,
Cindy M. - 07 Sep 2006 09:57 GMT
Hi =?Utf-8?B?SnVsZXM=?=,

Don't use "Selection", but a range that includes the entire "main story"
   Dim rng as Word.Range

   Set rng = ActiveDocument.Content
   rng.LanguageID 'and so on

> We have a custom data base application that merges with Word 2000 to produce
> documents.  The documents contain fields that are populated from the databse
[quoted text clipped - 16 lines]
> spellcheck manually with the result that only the first mispelled word is
> checked.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.