VBA Listview does not show correct characters

[mupan]

Several forms in our access product (file format Access 2000), a frontend to an SQL Server database, containing a MSComctlLib.ListViewCtrl.2.

We need to display characters like C caron in our lists. They are stored in the database tables, I can prove that in both SQL Server (Management Studio) and in the table view of the linked tables in Access.

The font set in the listview properties is "Arial" which is a Unicode font in every Windows version we are running our software on. SQL Server collation and Locale (substitution font for non-Unicode programs / program parts) are set to the target language which fixed every other character issue we had with this ... So I can't imagine which settings to check anymore or what to do to get around these problems.

Regards,

mupan

[mstraf]

Is this problem only in the ListView or in other components as well (for example a TextBox and a Label)
Remember that even if the Arial font is Unicode, the right CharSet (character set) font property needs to be set. I do not know about the C caron characters, sorry I can't help you with that.

[mupan]

Hello mstraf,

labels and textboxes and everything else are okay. It's only the listview that makes problems.

What do you mean by CharSet, where can I find this property?

C caron or C hatschek: čČ

Thank you so far.

mupan

[Hack]

The problem is the ListView control itself. It does not support unicode.

You would need to find a third party listview for that functionality. Years ago I remember seeing a listview control on VBAccellertor that did support unicode. You might try giving that site a search and see what you can come up with.

[mstraf]

ListView does not support unicode "internally" (like all other VB6 controls), but if you set the right CharSet font property it is able to display any type of font
I use for years a code taken from this article, and it works with any languages, for any component (including the ListView, using the property .Font.Charset)
http://msdn.microsoft.com/en-us/libr...8VS.60%29.aspx

[mupan]

Thank you mstraf, that was it. I'm glad I don't have to implement a listview alternative.