Hello,

I often need to work with double byte character fields (Japanese characters)
in my Access application. Now I have 2 questions.
1. How can I detect double byte character in a field ?
2. If possible, I want to convert double byte alphabet character to single
byte alphabet character. For example, if a field contains double byte
character "APPLE" (entry using Japanese character input method), I want to
convert it into single byte character "APPLE" (pure English character).

Any clue for this ?
thanks

TypeName() is a useful function but I'm not sure if it includes double byte
character variables.

"BB programmer" wrote:

> Hello,
>
> I often need to work with double byte character fields (Japanese characters)
> in my Access application. Now I have 2 questions.
> 1. How can I detect double byte character in a field ?
> 2. If possible, I want to convert double byte alphabet character to single
> byte alphabet character. For example, if a field contains double byte
> character "APPLE" (entry using Japanese character input method), I want to
> convert it into single byte character "APPLE" (pure English character).
>
> Any clue for this ?
> thanks

If you're working in Access 2000 or later, use a Unicode font and
questions like this become academic.

I've no experience with older double-byte character sets, and am
mystified by your distinction between a double-byte "APPLE" and a
single-byte one. You may be able to get somewhere by using AscW() and
Chr(). For instance, if C is a one-byte character (e.g. Latin "A")
encoded in two bytes,
C = Chr(AscW(C))
should (I think) be true, while if it's a double-byte Japanese character
it will be false.





On Thu, 20 Apr 2006 22:49:02 -0700, BB programmer
<(E-Mail Removed)> wrote:

>Hello,
>
>I often need to work with double byte character fields (Japanese characters)
>in my Access application. Now I have 2 questions.
>1. How can I detect double byte character in a field ?
>2. If possible, I want to convert double byte alphabet character to single
>byte alphabet character. For example, if a field contains double byte
>character "APPLE" (entry using Japanese character input method), I want to
>convert it into single byte character "APPLE" (pure English character).
>
>Any clue for this ?
>thanks

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.