Solved

ms/access 2013 spell check on a specific language

Posted on 2015-02-06
7
175 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
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.

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
ID: 40595545
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
ID: 40595599
Try "Spelling dictionary language" instead of "Dictionary Language"
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:jirdeaid
ID: 40595676
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
ID: 40595678
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
ID: 40596709
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
ID: 40596815
Thanks!!!!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

831 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