Display Chinese Characater in Access

[rickyfong]

I am using Chinese version Access 2000 to create an Access application. When I run that version in an English version Access. The table fieldnames, query description and all Chinese characters can be displayed correctly when running the application.
However, when I switched to the Event procedure i.e. the VBA coding. Then all the CHinese characters such as the fieldname that should be typed in the VBA program to do some process such as Dlookup() etc, had all changed to strange characater that I couldn't identify what are they?? Is there any way to display those Chinese character correctly in the content of ACCESS VBA programs?? Thanks!!

 

[John Big Booty]

I'm not a hundred percent sure but I suspect your operating system (Windows) would need to support the Chinese charter set.

 

[rickyfong]

Yes! I understand that or may be I need to have that Chinese code set in the PC which use the English version! Anyway, i just don't understand why the table fieldname and when running the applcation, all query and forms can display correctly all the Chinese character but not the programming sentence in those VBA programs!!

 

[darbid]

I have seen a similar problem as yours. I have a German/English XP operating system. I cannot use Chinese Characters in my VBA code and if I try to display it also in a message box it will not work.

I am going out of my depth here and someone might correct me but here goes.

I believe the reason for this is VBA is natively not going to support it. This is because it only supports ANSI and not Unicode.

Jet which is your database does support.

I had trouble with a "Ü" umlaut. It was in the name of a table. The tables worked fine on any computer but as soon as the table name was used in code it would not work.

You will not like this but if you want your mdb to work on non chinese computers then take out all the chinese characters.