how to detect language setting in Access 2007?

[Dave Reardon]

I have developed a portable database in Access 2007 which teachers can use to
write their student reports, and all works quite well, apart from one slight
niggle. Sometimes a person runs it on a machine at home which has the
language configured to the default English (US) which means when they run the
spell check it doesn't pick up English (UK) errors such as 'color' instead of
'colour' etc. What I would like to be able to do is to find the language
which is currently being used, and if anything other than English (UK) bring
up a warning message informing the user of the fact. Any suggestions
gratefully received!

Dave

 

[Douglas J. Steele]

Randy Birch has something that may address this at
http://vbnet.mvps.org/code/locale/localecountry.htm

(Obligatory warning: Randy's site is aimed at VB programmers. There are some
significant differences between the controls available for forms in VB and
in Access, to the point where some of Randy's samples will not port directly
into Access. This one doesn't look too bad, other than the fact that in VB,
you refer to the content of a text box by using its .Text property, and in
Access you use its .Value property)

 

[Dave Reardon]

Thanks Doug

Perfect - worked first time once I changed the .text to .value for each text
box, as you suggested.

Thanks again.

Dave