MS Access VBA unicode language strings change into meaningless characters.

[mshakeelattari]

In MS Access, when coding in VBA to show a string of any Unicode language (e.g., Arabic or Urdu, Persian, etc.) in a message box or textbox, it is changed into a strange language, e.g., �äÏÑÀ ãÇÑ�¡ Ïæ ÀÒÇÑ �Çä�-. Is there any solution for this other than going to settings/control panel and setting an alternate language for non-Unicode languages?

[SioSio]

Microsoft Office supports Unicode, but VB Editor (VBE) does not.
ChrW (charcode) function has no choice but to convert it for each character.

[SwissProgrammer]

SioSio, what version of VBE are you referring to? Does this apply to all of the VBE versions?

I thought that I was able to do this in VB6 sp5, but from your answer I am not certain what you are talking about. Maybe VB6 and VBE are different? I have not used VB6 in a long time and now I am wondering what you are talking about.

Thanks.

[SioSio]

Hi SwissProgrammer.

Visual Studio and VBE are not related.
VBE (Visual Basic Editor) is an integrated development environment software for creating VBA (Visual Basic for Applications) for Ofiice applications.

[twinnyfo]

All,

I've been working with Unicode in a project related to the Greek New Testament. I cannot use Unicode in the VBE--nor even in VBA--I must always make references to variables which have been saved in a table, make my comparisons and manipulations using the ChrW() function and then save directly back to the Table.

It is a round-about way of doing things, but it is the only way to work with Unicode in VBA/Access.

Hope this hepps!

[SwissProgrammer]

Thanks SioSio.

I do not think that I ever used the VBE for VBA. I think that I recall just writing in VB6 then when I got the program done I converted to VBA, or used it as-is instead of VBA. Your way sounds easier. I will try to remember it if I have to use VBA again.

mshakeelattari, I think that twinnyfo has the first part of your answer, then use that with SioSio's guidlines but maybe try to write it in VB6. VB6 works natively in Unicode. All text that you work with in VB6 is converted to Unicode then that is used via unicode then the result is reconverted to your chosen code-page. I think that you have your answer in those posters, but you might have some work to do.

If all this fails, then an option that I used to use was to use VB6 to subclass the difficult program, then control it via the VB6 program.

If you want to see the Unicode that VB6 is sending to you, then use a RichTextBox. You might have to learn how to parse rtf, but I found it worth the effort. ????? in a text box vs the correct hiragana or katakana or etc. characters in a RTF box is better.

If you want to try that, then see my article at https://bytes.com/topic/software-dev...ow#post3828472 for some general ideas.

幸運を

[Tomcruisesmart]

Visual Studio and VBE are not related.Visual Basic for Applications is a software development environment that can be integrated to create VBA Visual Basic for Applications for Office applications.