Why is recordset returning ? instead of Japanese character.

[Ziggurat]

Hi All,

I have a curious problem and I hope that someone out there will be able to help me.

I have a table in an English version of MsAccess 2007 which contains various fields and in one of the fields is a single japanese character. When displaying the table, the japanese character is displayed no problem.
When a query is created from the table, the query shows the character. Again no problem.

However, when I write VBA code to handle the data using a recordset to loop through the records in the table, the recordset returns ? (a question mark) instead of the character.

I am sure it must have something to do with the character encoding eg UTF-8, Shift-JIS or something but I don't know how to change it. I have tried using StringConv() but to no avail.

Does anyone have any ideas what could be wrong.

Thank you in advance.

#
###
#####
#######
Ziggurat

 

[kjv1611]

Usually, a program will return a ? for a character it does not have in the font library, best I recall. If you have the Japanese fonts installed, perhaps you need to reinstall it, or perhaps you need a different Japanese font? I'm just assuming there'd be more than one.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57