Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

spell check in design view

Posted on 2011-03-08
11
Medium Priority
?
647 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 - Microsoft MVP, Access and Data Platform) earned 800 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 600 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 8

Assisted Solution

by:hello_everybody
hello_everybody earned 600 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

916 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