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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
J.R. SitmanIT DirectorAuthor Commented:
thanks.   Seems odd getting help from you on EE.
0
J.R. SitmanIT DirectorAuthor Commented:
Thanks to all
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.