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
smiechel said:
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?