A Unicode VBA IDE?

Hello experts! I've created an Access application on the idea of flashcards for learning new languages.
After you get into the application you choose which language you want to study. Then you  can watch a series of "cards" I had prepared, with words in the foreign language, and play some games with them etc. You can also insert new foreign words if you want.
My language is Hebrew, so my codepage in windows is Hebrew. This enables me to write some Hebrew in VBA code, for displaying MsgBox with Hebrew messages and so on.
The problem is: once my codepage was set to Hebrew, I can't write anything in the foreign language into VBA code - things like "u" with 2 dots over it for German or Turkish, c with a cedilla underneath for Portuguese, the special yumushak-G for Turkish, or any other foreign characters not present in the basic char-map of English/Hebrew. If I set windows codepage to Turkish, I would be able to write Turkish characters in VBA code, but not any other foreign characters of other languages, and so on.
Is there a way to overcome the non-Unicode-nature of VBA environment? Thank you.
Who is Participating?
als315Connect With a Mentor Commented:
You can't mix codepages in VBA editor. It doesn't support unicode.
You can only add unicode to text strings with chr function. For example, open word, find nesessary symbol:
symbolyou can add this symbol to any text string with ChrW function: str = str & ChrW("&H016C")
Here you can find other approach to this problem:
You can write unicode text to tables and show message according selected language
NNOAM1Author Commented:
Ok. I managed to work around this problem using data stored in tables. Still, Aren't there any VBA functions to convert character-codes into some other codes and this way to write some Unicode text directly in VBA?
NNOAM1Author Commented:
Thank you!
All Courses

From novice to tech pro — start learning today.