How to detect double byte character fields ?

[BB programmer]

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

 

[Martin]

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

 

[John Nurick]

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.