Recordset charset option for displaying Chinese correctly

[Medwar19]

Hi All,

I have localized data in 9 languages in my Access 2010 tables, and all strings display correctly formatted in Access tables and queries.

I need to use the strings to lookup strings in other tables but when I open a DAO recordset in VBA the characters (for symbolic languages such as Greek/Chinese) do not pass through correctly (characters appears as ? marks).

This means I can not use the strings...

Is there a way of setting the charset to be used when I open the recordset?

Thanks,

Mark.

[Medwar19]

So it turns out that the symbolic languages are passed to VBA correctly, they just show up as ? marks in the strings and watch window. Running the code through VBA I found the correct symbols are passed back out to the table.

Result!