Any experts in MS access here?

[BaldPlumber]

I have a problem with toggling access forms to display either the Roman / Latin character set and the Thai character set.

 

If someone has done this before I would be very grateful for some advice.

 

My problem is this ...

 

I am using a font that supports both Latin and non-Latin, including Thai. If I hard code any controls caption property within design view, the form will render correctly.

 

However, if I change the caption property on, say, form load in my VBA code, the form will not render properly. In fact, it won't include any Thai characters.

 

It makes no difference if I reset the font name to the exact same one specified in design view.

 

I've tried the various expert forums, but the amount of people with experience of non-Latin based coding seems to be in short supply. Hopefully I'll have better luck here!

 

Any help greatly appreciated.

 

 

[BaldPlumber]

Problem solved.

I doubt anyone is interested but it turns out that VBA variables cannot contain unicode and a different technique is needed.