• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1781
  • Last Modified:

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.
0
NNOAM1
Asked:
NNOAM1
  • 2
  • 2
1 Solution
 
als315Commented:
You can write unicode text to tables and show message according selected language
DBmultilang.accdb
0
 
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?
0
 
als315Commented:
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:
http://www.utteraccess.com/forum/index.php?s=&showtopic=1721616&view=findpost&p=1722020
0
 
NNOAM1Author Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now