How do you edit a Microsoft Access dictionary

One user is stating that when she does a spell check in our Access database it does not correct all the misspelled words.

So I thought I would start by editing what is in it.   How?
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
mbizupCommented:
>> Any thoughts what would cause this?

Only that they might inadvertently be trying to add a word that is already in the dictionary.  Otherwise, as Scott suggested, try repairing Office.
0
 
Fabrice LambertFabrice LambertCommented:
Erm, can you elaborate ?
Where are those "mispelled words" ?
0
 
mbizupCommented:
Under the file tab
- Options
- Current Database
- Proofing

From the Proofing window, you can change Autocorrect Options or add/edit custom dictionaries.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Spell Check is part of Office. If they have troubles with the dictionary, a REpair of Office will often correct that.
0
 
mbizupCommented:
That said... I'm not sure about Access 2016, but I think that autocorrect has been a known source of problems in Access databases in past versions (others can verify or correct me on that) .

EDIT:

Digging into this... It's just 'Name AutoCorrect' which is a problem.  See the following:
http://www.allenbrowne.com/bug-03.html
0
 
J.R. SitmanIT DirectorAuthor Commented:
Can users add words to the dictionary
0
 
J.R. SitmanIT DirectorAuthor Commented:
How do I allow users to save to the dictionary?

dictionary
0
 
J.R. SitmanIT DirectorAuthor Commented:
The misspelled words are in a text box for Vet notes
0
 
Bharat BhushanSolution ManagerCommented:
You mean the Object Library or just the dictionary?
If just the dictionary I seem to remember being able to edit the dictionary from Word but not directly in Access.
0
 
Bharat BhushanSolution ManagerCommented:
Oh well then nope it won't catch those unless you specifically run spell check on the text box.  Never has
0
 
mbizupCommented:
Try this, from  Proofing -> Autocorrect Options:
Capture.PNG
0
 
J.R. SitmanIT DirectorAuthor Commented:
All of the Autocorrect boxes are already checked.  The users cannot add to the dictionary.   However, from the .accdb it can be added to.
0
 
mbizupCommented:
Did you try adding 'adop' to the replace box and 'adopt' to the  Replace With box as in the screenshot I posted?  This works for me with files in either .accdb or .accde format... but that may also be because I have Access installed, not just the Access Runtime.  

If the users are unable to do this through the .accde then it may not be possible.  As far as I can tell you cannot control this through Access VBA like you can in Word and Excel.
0
 
J.R. SitmanIT DirectorAuthor Commented:
I did not try that.  What I was hoping was to get the "add" button active in my screen shot.
0
 
mbizupCommented:
That screen I posted is also reachable by clicking the Options button at the bottom of your screenshot, and then Autocorrect Options.

Are you sure that using the 'Add' button in this instance is correct?  If you add 'adop' to the dictionary, then it will not get picked up as an incorrect spelling of 'adopt'.
0
 
J.R. SitmanIT DirectorAuthor Commented:
the issue was that the "add" button was greyed out in the accde.   For whatever today it is working.   I have had a user tell me that sometimes it works and others it does not.  

Any thoughts what would cause this?
0
 
J.R. SitmanIT DirectorAuthor Commented:
thanks.   Seems odd getting help from you on EE.
0
 
J.R. SitmanIT DirectorAuthor Commented:
Thanks to all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.