Solved

How do I enable the squiggly red underline in Microsoft Access for spell checking?

Posted on 2012-04-10
5
699 Views
Last Modified: 2012-04-20
I would like to be able to have automatic spell checking in tables and forms. How do I enable this? Thanks!
0
Comment
Question by:DataDudes
  • 3
5 Comments
 
LVL 16

Expert Comment

by:kmslogic
Comment Utility
That feature doesn't work in the background in Microsoft Access--sorry.  You can still set up autocorrect entries under Options->Proofing to automatically fix common misspellings.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
You can invoke the spell checker on any field with code like this:

Me.SomeControl.SetFocus
DoCmd.RunCommand acCmdSpelling
0
 
LVL 2

Author Comment

by:DataDudes
Comment Utility
Where do I put that code in a table?
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
On the click event of a button on the form
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<Where do I put that code in a table?>
No possible, use a form.

you can make a datasheet view form and it will look the same as a table
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now