Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Code/macro for spellcheck

Status
Not open for further replies.
LeiDBug007

LeiDBug007

Technical User
Oct 15, 2003
33
US
Greetings Experts,

We've got a memo field that users enter their notes on each case. We would like the spellcheck feature/command to run (when needed) on misspelled words.

Your expertise is much needed, thanx!

~LeiDBug007
 
Sort by date Sort by votes
Put this code in beforeupdate, afterupdate, or onexit!


DoCmd.SetWarnings False 'Turn off System Warning if spell check returns no error.
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True 'Turn back on the System Warnings
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
384
mattKnight
mattKnight
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
306
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
655
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
111
Andrzejek
Andrzejek
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
252
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top