How to make vba to read and understand characters in other keyboard language

[MBMSOFT]

How to make vba to read and understand characters in other keyboard language

e.g
****************************************************
Private Sub A_AfterUpdate()

If Not IsNull(Me.A) Then

' This is not understandable for vba and in editor is writen with
' unureadable characters
If Trim(Me.A) = "ХШЃЧЌЧЧЃ ШЏФЊЕФР" Then

Me.B = "X"
Else
Me.B = "MKD"
End If
Else
Me.B = Null
End If
End Sub
***************************************
as weel

msgbox "асфјлкфмвкосслчд фдсфлчсдф"
is shown with unreadable characters
or
msgbox me.a.text
is shown with "???????????????"

should i turn on some references in VBA
or install some feattures
thanks

 

[darbid]

I see you are in Language hell. Everyone should just have a date format of mm/dd/yyyy speak american english and we would be good to go with MS Office.

Your findings are "normal", by that I mean that in the VB editor and if you use message box it will show ??????????. It does for me with Japanese and Chinese as well.

I do not have a solution for your peoblem.

My work around for the VB editor is that I write my text to a text file and then I read that text file.

The problem which you have to solve is that natively Access is using only ANSI - which does not cut it for all the extra characters. You need to change this to Unicode. Secondly you need the office and windows language packs.

I have only managed to do this with my text file, with reading this text file. and with captions and text on a form. I have not managed it with the editor.

 

[MBMSOFT]

Finally I found solution.. it simple, so if someone need this here it is>>>

1.In Control Panel > Regional and language options> advanced tab
choose the native language you want to use in language for non-unicode programs

2.In VBA editor choose tools>options>editor format> font which support your language
and it will work fine

 

[darbid]

Thats a good find. Thanks for sharing that.