Solved

spell check in design view

Posted on 2011-03-08
11
630 Views
Last Modified: 2012-06-27
In Access 2007 is it possible to use Spell check on form and report labels in design view?  If it is possible, then how do I accomplish this. I know that 2007 has error checking that will cause a flag to come up by a label or control, but I am not seeing a setting for Spell Checking.
0
Comment
Question by:BradleyCleveland
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 35077978
I don't think so.  If you hit F7 in design view ... it opens the VBA editor.

mx
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 150 total points
ID: 35084261
0
 
LVL 75
ID: 35085127
I should have known better, lol.  I beta tested the original FMS Spell Check for Access 1.1.

mx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Assisted Solution

by:hello_everybody
hello_everybody earned 150 total points
ID: 35085213
Or you can use Developer Spell Check Engine for Access 4.0 at: http://www.pieproducts.com/products.htm

Design-mode spell checking of Microsoft Access and/or Visual Basic projects.
Check everything the end-user will see using a variety of functional and spell check options. Checks Everything MsgBoxes, Captions, StatusBarText, ControlTipText, Forms, Reports and Code Modules.
Conveniently spell check your Forms, Reports and Code Modules in design mode;
Check everything: Captions, StatusBarText, ToolTipText, Tag Properties and Modules;
Options for checking Literal Strings and Comments only in Code Modules;
Saves you professional embarrassment of misspellings;
Build MsgBox’s and InputBox’s visually;
Spell Check your MsgBox’s and InputBox’s;
Build Logic code with your MsgBox’s and InputBox’s;
Create formatted Msgbox’s;
Use your own procedure variables with the “%%” keys in your MsgBox’s and InputBox’s;
Use quotes (“”) in your Msgbox’s and InputBox’s;
Generate Windows Sound System code with your MsgBox’s and InputBox’s;
Spell Check any text that has been copied to the Windows clipboard;
Check Literal Strings only in the Clipboard Tab;
Right click text marked in red to correct “Spelling As You Type” mistakes;
Edit spell check dictionaries;
Create custom user dictionaries;
Create and edit “Auto-Replace” dictionaries for common typing mistakes;
Control the spell check options;
Get the clipboard text with a Push of a button; Intelligent text copying with selected text;
Set the Default start-up tab to suit your preference;
“Spell As You Type” functionality for MsgBox, InputBox and Clipboard text fields.
0
 
LVL 75
ID: 35085242
Access 4.0 ?
No Such version
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35085448
MX, the 4.0 refers to the version of the software package...

Put another way...
Developer Spell Check Engine v4.0,  for Access

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35086192
hello_everybody,

In the same vein, ...

It is not clear if this product is compatible with anything newer than Access 2002/XP.
...?

JeffCoachman
0
 
LVL 75
ID: 35086415
I would recommend the FMS product ... for sure that is ...

mx
0
 
LVL 8

Expert Comment

by:hello_everybody
ID: 35086649
JeffCoachman:

Your right, it isn't compatible with anything newer than Access 2002/XP.
0
 
LVL 1

Author Comment

by:BradleyCleveland
ID: 35149947
So what I am hearing is that this functionality is not built into Acces and its going to require purchasing a thrid party tool?
0
 
LVL 75
ID: 35149988
I would say that is the case ...

mx
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

751 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