Display EUC-Encoded field on Access 2007?

[jackbenimble999@gmail.com]

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

[jackbenimble999@gmail.com]

Re: Display EUC-Encoded field on Access 2007?

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![txtDisplayUnico deAsChar] = 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