Solved

spell check in design view

Posted on 2011-03-08
11
619 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
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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
 
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

932 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