Labels wont display Hebrew characters

[Movian]

We are trying to setup our system to be multi lingual.

We have had no problems with other languages based on our alphabet however I am having a problem with languages with non roman alphabets.

(Hebrew specifically to start) - We have installed the additional fonts and language packs, and have no trouble displaying the hebrew text in text boxes etc etc.

But when we try and set a label in access to Hebrew text in replaces all the characters with question marks ???

Any thoughts?

[Movian]

After a few more hours investigation it looks like the problem is not with the labels but rather accepting the text through an input box seems to be causing the problem... does the input box only accept certain encoding formats ?

[SamT]

Making your VB code ready to go global (Matt Gertz)
(http://blogs.msdn.com/b/vbteam/archive/2007/03/08/making-your-vb-code-ready-to-go-global-matt-gertz.aspx)
Issues Specific to the Double-Byte Character Set (DBCS) (http://msdn.microsoft.com/en-us/library/aa242129%28v=vs.60%29.aspx)

DBCS String Manipulation Functions (http://msdn.microsoft.com/en-us/library/aa716189%28v=VS.60%29.aspx)

Internationalization for Windows Applications (http://msdn.microsoft.com/en-us/library/dd318661%28v=vs.85%29.aspx)

Google double byte ascii characters (https://www.google.com/#output=search&sclient=psy-ab&q=extended+ascii+or+double+byte+characters&oq=double+byte+ascii+characters&gs_l=hp.1.1.0i22i30l2.2306.2306.0.9310.1.1.0.0.0.0.1134.1134.7-1.1.0....0...1c..22.psy-ab..0.1.1116.DLSBytxTRV4&pbx=1&bav=on.2,or.r_qf.&bvm=bv.49784469,d.cGE&fp=4de561cb9c385843&biw=1024&bih=666)

Bing global development dbcs unicode vb (http://www.bing.com/search?q=global%20development%20dbcs%20unicode%20vb&FORM=BMME)

[Movian]

Some awesome links!

Thanks for the references, this is the first time i have done a set of coding changes to get a system ready for multiple languages and will be referencing those docs heavily!!
Will see if I can get the System.Globalization to work in VBA

Havn't solved the input box issue just yet but the Double character information looks like it may be the key. Once I have the exact solution I shall put my fix into the threat and mark solved.

[Movian]

Buffering the string that gets passes to the function that stores the label value instead of sending it directly through using the inputbox seems to have resolved the issue

OLD Code

EditLabel(screen.activecontrol.name, inputbox("Please enter your new value"))

NEW Working Code


dim tempText as string
temptext = inputbotx("Please enter your new value")
editlable (Screen.activecontrol.name, temptext)