Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

ms/access 2013 spell check on a specific language

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?
0
João serras-pereira
Asked:
João serras-pereira
  • 4
  • 3
3 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.

https://support.office.com/en-ca/article/Check-spelling-and-grammar-in-another-language-de22dd18-2766-4243-8a98-8963c6726ee4

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.

https://msdn.microsoft.com/en-us/library/office/aa221603(v=office.11).aspx
0
 
João serras-pereiraAuthor Commented:
Thanks... I am getting an error:

ss1


ss2

any cues?

(ms MS/ACCESS 2013 is in englush
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Try "Spelling dictionary language" instead of "Dictionary Language"
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
João serras-pereiraAuthor Commented:
nope...

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...
0
 
João serras-pereiraAuthor Commented:
oops..


ss1

Screen-Shot-2015-02-07-at-18.23.55.png
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You need to use the Language constant, which I believe would be msoLanguageIDPortuguese:

https://msdn.microsoft.com/en-us/library/aa432635(v=office.12).aspx
0
 
João serras-pereiraAuthor Commented:
Thanks!!!!
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now