Solved

ms/access 2013 spell check on a specific language

Posted on 2015-02-06
7
161 Views
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?
0
Comment
Question by:jirdeaid
  • 4
  • 3
7 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
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
 

Author Comment

by:jirdeaid
Comment Utility
Thanks... I am getting an error:

ss1


ss2

any cues?

(ms MS/ACCESS 2013 is in englush
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
Try "Spelling dictionary language" instead of "Dictionary Language"
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:jirdeaid
Comment Utility
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
 

Author Comment

by:jirdeaid
Comment Utility
oops..


ss1

Screen-Shot-2015-02-07-at-18.23.55.png
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:jirdeaid
Comment Utility
Thanks!!!!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now