Converting Access 2000 forms, etc. to Spanish at runtime

[tyracg]

I wrote a project in Access 2000 and SQL Server 2000 in English, but I am looking for an fairly easy way to translate all forms, reports and message boxes to Spanish without having to use a human translator because I am constantly changing the project. My main concern is on the message boxes, there are several hundred message boxes in my project. It would be perfect if I could just replace the text string for the message box with a function that would automatically translate any string I passed to it into Spanish. The VBA code for all message boxes in the project would look something like this: msgbox(EnglishToSpanish("This order is already delivered!&quot,vbOKOnly + vbExclamation,EnglishToSpanish("ORDER ALREADY DELIVERED!&quot). Does anyone know if this is somehow possible? Thanks for any suggestions.

 

[fheyn]

Though I'm not a very experienced Access2000 programmer I'd
like to give you some advice because I just finished working
on a project that uses a multilingual concept.
I think the idea of a translater (which easily could be larger then your application) isn't very good because
even the socalled good programs won't translate correctly.
A better solution is using a language table to store the
messages in either language and use a language-flag to get
the right message.