• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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