Multiple Languages

[smiechel]

We have developed a MSAccess 2002 application in English and now wish to distribute it to multiple countries using different languages. What is the best method for changing the labels and captions on forms, reports, etc, so that the language used is based on the user logged in?

 

[Adrian Jansen]

You can set up a table to hold all the captions, then load them from the
table to the form/report as the form loads. Distribute an appropriate table
for the language needed for the area. Or even create a multi-language
table, and load from the correct language based on the user, if you want to
go that far.

The biggest headache is the fact that different languages have different
length words, and a caption may not fit a word in a new language. Takes a
lot of checking and adjusting.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

We have developed a MSAccess 2002 application in English and now wish to

distribute it to multiple countries using different languages. What is the
best method for changing the labels and captions on forms, reports, etc, so
that the language used is based on the user logged in?

 

[StCyrM]

As mentioned by Mr. Jansen the biggest problem the space required for the
captions and the text boxes to accommodate the data. In my case, I have
created numerous bilingual applications (French/English)

As far as switching between languages, that is quite simple.

Maurice St-Cyr
Micro Systems Consultants