Change text before generating report

[Ixak]

Hello
I have a textbox which contains the month and year.
It calculates as =Format$([soldmonth];"mmmm aaaa";0;0)
I´d like to obtain this information, august 2006 and convert it in another
textbox, in something else, another language.
something like

if soldmonth.caption or value = "august 2006" then
texttranslate.caption or text = abuztua 06
else
if soldmonth.caption or value = "june2006" then
texttranslate.caption or text = ....

Where and how should I write this code?
I mean, I don´t get with this options and I don´t know in which event I
should write them. When opening the form, or ...
Thanks

 

[pietlinden]

Hello
I have a textbox which contains the month and year.
It calculates as =Format$([soldmonth];"mmmm aaaa";0;0)
I´d like to obtain this information, august 2006 and convert it in another
textbox, in something else, another language.
something like

if soldmonth.caption or value = "august 2006" then
texttranslate.caption or text = abuztua 06
else
if soldmonth.caption or value = "june2006" then
texttranslate.caption or text = ....

Where and how should I write this code?
I mean, I don´t get with this options and I don´t know in which eventI
should write them. When opening the form, or ...
Thanks

Why not just create a table containing all the translation stuff you
need (the months)
8, "August", "abuztua" etc. and then use the table to do the
translation for you? just use DLookup