?
Solved

ms/access 2013 spell check on a specific language

Posted on 2015-02-06
7
Medium Priority
?
182 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:João serras-pereira
[X]
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
7 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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:João serras-pereira
ID: 40595545
Thanks... I am getting an error:

ss1


ss2

any cues?

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

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40595599
Try "Spelling dictionary language" instead of "Dictionary Language"
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:João serras-pereira
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:João serras-pereira
ID: 40595678
oops..


ss1

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

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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:João serras-pereira
ID: 40596815
Thanks!!!!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

771 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