By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,656 Members | 1,918 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,656 IT Pros & Developers. It's quick & easy.

Display EUC-Encoded field on Access 2007?

P: n/a
Hello!

What is the best way to display a EUC-encoded field with Access 2007?
Or, failing that, how do you display a Unicode field as the character
instead of the number? Do I need to use a browser control? I have
created a local web page which successfully displays a Unicode
character when I bring it up using a standard browser, but so far I
haven't been able to figure out how to get the WebBrowser control to
navigate to the page - it doesn't seem to have a "navigate" method.
If I can get that working, then I can find or write a method to
convert from EUC to Unicode.

Thanks!

Jack B. Nimble
Feb 9 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Good news!

The solution seems to be the following:

1) Convert the EUC code to Unicode values using the standard decoding
(I still have to find/write that code)

2) Once you have the Unicode, convert it to a long using a statement
like this:
lngUnicode = CLng("&H" & Trim(Me![Unicode]))

3) Use ChrW function to display it as (wide? as in double-byte?) a
unicode charachter.

Me![txtDisplayUnicodeAsChar] = ChrW(lngUnicode)

4) Make sure the display field uses a font which includes the
characters you want (e.g. MS Mincho for Japanese)

Jack B. Nimble

On Feb 9, 3:25 pm, jackbenimble...@gmail.com wrote:
Hello!

What is the best way to display a EUC-encoded field with Access 2007?
Or, failing that, how do you display a Unicode field as the character
instead of the number? Do I need to use a browser control? I have
created a local web page which successfully displays a Unicode
character when I bring it up using a standard browser, but so far I
haven't been able to figure out how to get the WebBrowser control to
navigate to the page - it doesn't seem to have a "navigate" method.
If I can get that working, then I can find or write a method to
convert from EUC to Unicode.

Thanks!

Jack B. Nimble
Feb 9 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.