Change menu language

[DigiTomi]

Guys,

I search the forums but did not find the answer to this:

I have custom menus and forms in my database. What I want to have is an option that the user could change the language in which the menus and forms are displayed. I thought about a table where I translate all menus into different languages, but don't know how to start.

Thanks for any ideas.

Cheers

 

[gemma-the-husky]

Yes you would have to have a table where all text strings are stored in numerous languages.

It depends how far you need to take this - you will have label names, form headers, msg boxes etc - alll kind of things. Everywhere you use them you would then have to update the text to the correct value.

I suppose one way would be to store an "ActiveText" column in the language table, and on change of language copy all the language text into the activetext column.

Then all your code, forms etc need to pick up whatever they need to display from the "ActiveText" column of the language table.

It seems like a significant job to me, though.

 

[DigiTomi]

Thanks gemma-the-husky,

My problem is when I try to display the text I define as active. I can not use any function in the menu caption bar. Please see attachment.

Thanks

 

[gemma-the-husky]

Sorry, I can't really help. I think this is a very very complex thing to try and achieve.

The code I've seen to do this stores the variant texts in a table, and stores details of the language required in the tag property of any control that needs changing for the language context. Then when the form or report is opened, in the open event, you have to iterate all the controls and reset the caption or text accordingly based on the language required and tag setting.