Solved

spell check in design view

Posted on 2011-03-08
11
634 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
Technology Partners: 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

624 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