ms/access 2013 spell check on a specific language

Posted on 2015-02-06
Last Modified: 2016-02-11
I need to spellcheck a field in ms/access. I have browsed for a solution which I found using the docmd.
But I need to specify the language (Portuguese from Portugal)
How do I do it?
Question by:jirdeaid
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
  • 4
  • 3
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40595478
The spell check engine uses the language setup in Access, which is the language setup in Windows (by default). You can change that language, and then run the spell check.

I believe you can write that option using SetOption:

Application.SetOption "Dictionary Language", "Your Language"

I'm not sure exactly which language you'd use for the second argument. I'm also not sure if this option will "stick" without having to restart the database.

Author Comment

ID: 40595545
Thanks... I am getting an error:



any cues?

(ms MS/ACCESS 2013 is in englush
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40595599
Try "Spelling dictionary language" instead of "Dictionary Language"
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!


Author Comment

ID: 40595676

please check the screenshots below.

The code is within the "boot" section of the application so I think that there will be no problem on the need to reboot access...

Author Comment

ID: 40595678


LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40596709
You need to use the Language constant, which I believe would be msoLanguageIDPortuguese:

Author Closing Comment

ID: 40596815

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

726 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