Hi Peter,
It's a bit of a shame that you have to dig this deep to set the language on
a form field. I'm applying a workaround that replaces English months with
their Dutch translations when the user exits the last form field. This is
somewhat easier, and it works - it doesn't solve the problem, though.
Thank you for cooperating,
Cooz
"Peter Jamieson" wrote:
Looking a bit further, the Primary Editing Language appears to be the
one defined in
Application.LanguageSettings.LanguageID(msoLanguag eIDInstall)
but this is a read-only value.
If you can modify the registry, you can certainly set the value in the
following item - this is for Word 2007, for the current user
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\LanguageResources\InstallLanguage
and ensure that there is an entry to the list in
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\C ommon\LanguageResources\EnabledLanguages
e.g. for Dutch (Netherlands), use 1043 decimal. (I think Word will
automatically add the Primary Editing Language to that list but haven't
looked that hard).
That said,
a. it's quite possible you can't access the registry either on the Pc
where you do not have the Office Language settings tool
b. I don't know if you can set the language for all users on the
system via the LOCAL_MACHINE registry hive, or whether you would even
want to.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Cooz wrote:
Hi Peter,
I take it that with "Primary Editing language" you mean the "language that
defines the default behavior in Microsoft Office applications" (Start | All
Programs | Microsoft Office Microsoft Office Tools Microsoft Office 2003
Language Settings | tab "Enabled Languages"). That's indeed the one that
spoils the form field behavior.
Whenever I set this option to English, date format fields in Word spit out
the English format, no matter what else is defined language-wise in your Word
documents. Unfortunately the company that I work for doesn't make this option
available to its users - but my laptop does. I will have to find some IT boss
over here that can access this setting - and change it.
Thank you,
Cooz
"Peter Jamieson" wrote:
I had a look at this a few months ago.At that time I thought that
a. the language used to display these dates is the "Primary Editing
language" that is set in the Office Language Settings.
b. the language settings in Control Panel regional options, the
language of the paragraph/style, and the language currently used for
input do not seem to affect it at all.
(With ordinary fields (e.g. REF fields) date formatting does take
account of the language of the text, but attempting to apply a date
format switch within the FORMTEXT field makes no difference.)
So it is worth checking that. However, since it sounds as if your entire
system is set up for Dutch use, the "Primary Editing language" will also
be Dutch and my hypothesis will be wrong. If so, I'm not sure I will be
able to find a solution, but let me know. I may only have looked at Word
2007.
Groetjes,
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv
Cooz wrote:
Hi everyone,
I have a Dutch version of Word 2003, and I work with Dutch texts in Dutch
documents, in which the language is set to Dutch.
I insert a text form field with the type set to Date and the Date format to
"d MMMM", protect the form and type 6-6 in the field. I press the tab key.
The field result is "6 June".
It's English!
What can I possibly do to retrieve Dutch dates?
Thank you,
Cooz