Access 2002 : How can I with a vba module, caption Polish Charact.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have developed a multi-language application under Access 2002.
By a simple click on a button the user can switch from English to French,
German or Dutch. This is particularly interesting for countries like
Switzerland where the people speak different language at head quarters.
Now.. we have been requested to extend the language with Polish and we are
unable to do so. We use the VBA label caption instruction
(Form_Name.Label_Name.Caption = "Hello") but our Polish characters are shown
in the form labels as 'Hieroglyphs'. Who could put us on the right track?
Best regards Roger
 
Does the font being used for the captions support the Polish character set?
 
Hi,
i think if you would store captions in the access tables, which support
unicode, then it should work.
VBA IDE does not support unicode, so you can't type there say russian and
german
 
Thanks Douglas
In the beginning we tried Unicode but as Alex Dybenko confirms VBA IDE does
not allow Unicode. It's either Arial Western or Arial CE.
So we forgot about the Western characters and tried only Arial CE.
Therefore we installed font Arial CE in the module (VBA option - otherwise
we would be able to write Polish characters) and in the label properties of
the form. We also tried to use the instruction fontName = "Arial CE". The
problem is identical. No Polish characters in the labels.
It looks like VBA converts the Polish characters back to the Western
Character map.
This problem is even worse for us since we have also message boxes and
Office assistant balloons where the Polish characters appear as ufo's.
Roger
 
Thanks Alex,
Part of my reply is given to Douglas.
You are right concerning the tables and its Unicode, but unfortunately we
can not use tables for practical networking reasons.
Roger
 
Hi Roger,
Part of my reply is given to Douglas.
You are right concerning the tables and its Unicode, but unfortunately we
can not use tables for practical networking reasons.
Click to expand...

well, i mean tables in frontend MDB
 
Hi Roger,
In the beginning we tried Unicode but as Alex Dybenko confirms VBA IDE
does
not allow Unicode. It's either Arial Western or Arial CE.
So we forgot about the Western characters and tried only Arial CE.
Therefore we installed font Arial CE in the module (VBA option - otherwise
we would be able to write Polish characters) and in the label properties
of
the form. We also tried to use the instruction fontName = "Arial CE". The
problem is identical. No Polish characters in the labels.
It looks like VBA converts the Polish characters back to the Western
Character map.
This problem is even worse for us since we have also message boxes and
Office assistant balloons where the Polish characters appear as ufo's.
Click to expand...

Also you have to change default locale on PC to Polish or something similar.
i think translation non-unicode to unicode is performing based on default
locale settings
HTH
 
Hello Alex,
Sorry for the delay. We had to do some tests.
It seems that we were going into a direction that MS Access cannot perform.
As long is we stayed within the western language there was no problem with
our application.
The combination of western and eastern language within the same databank
works perfectly well using the frontend language table. So we have to make a
180 degree turn.
You have put us back into reality. We have a lot of work to do for adapting
our application, but we have … a solution.
Alex, thank you very much for your help.
Roger
 
Back
Top