Displaying Asian languages on a form

[George H. Slamowitz]

Hello all

I am trying to store in a table and display on a form freign languages like
Chinese, Korean, Japanise, etc.

Can anyone please share with me where I can go to get some information on
how to store these languages in a table and how to display them on a form
and/or a report.

Any help would be greatrly appreciated.

Thanks in advance

 

[User]

If you are using Acc2000 or later and Win2K or later there is very little
that needs to be done.

For Win2K you have to install the required East Asian fonts for Chinese,
Japanese, and Korean.
by going to Control Panels->Keyboard->Input Locales.
The fonts will help you display and the input method editors will help you
enter data.

Acc2000 by default stores text as unicode (compressed) so there is no "code
page" stuff to worry about.
The Access textboxes must have their display font set appropriately (and
datasheets also).
One problem is that if you choose a Chinese font, it will not display
Japanese correctly, and vice versa.
(If you choose a Latin font like Arial, then it will display neither
Chinese/Japanese/Korean)

One solution is to install and use the "Arial Unicode MS " font (available
from the Office 2K cd/install options) which simultaneously contains symbols
for many of the worlds languages. Needless to say, this is a big font file.
[from MS]
"Note Because of its considerable size and the typographic compromises
required to make such a font, Arial Unicode MS should be used only when you
can't use multiple fonts tuned for different writing systems. For example,
if you have multilingual data from many different writing systems in
Microsoft Access, you can use Arial Unicode MS as the font to display the
data tables, because Access can't accept many different fonts."

Another way is to choose the Tahoma font, wherein I have found that
Office/Win2K will then substitute the required Chinese/Japanese/Korean fonts
when required, even on a character by character basis.


You can also look in the Office 2K help files under "About multilingual
features in Office"

 

[George H. Slamowitz]

Your hit worked great ... when I saw ig chinese letters in the table all I
was seeing was little boxes (and currently see them, I don't know if that
could be corrected) , but when I put it into a form uising the the font you
recommended it workd fine.

One other question, do you have any hits on hou to get the controltip text
to display in the same foreign language?

George

If you are using Acc2000 or later and Win2K or later there is very little
that needs to be done.

For Win2K you have to install the required East Asian fonts for Chinese,
Japanese, and Korean.
by going to Control Panels->Keyboard->Input Locales.
The fonts will help you display and the input method editors will help you
enter data.

Acc2000 by default stores text as unicode (compressed) so there is no "code
page" stuff to worry about.
The Access textboxes must have their display font set appropriately (and
datasheets also).
One problem is that if you choose a Chinese font, it will not display
Japanese correctly, and vice versa.
(If you choose a Latin font like Arial, then it will display neither
Chinese/Japanese/Korean)

One solution is to install and use the "Arial Unicode MS " font (available
from the Office 2K cd/install options) which simultaneously contains symbols
for many of the worlds languages. Needless to say, this is a big font file.
[from MS]
"Note Because of its considerable size and the typographic compromises
required to make such a font, Arial Unicode MS should be used only when you
can't use multiple fonts tuned for different writing systems. For example,
if you have multilingual data from many different writing systems in
Microsoft Access, you can use Arial Unicode MS as the font to display the
data tables, because Access can't accept many different fonts."

Another way is to choose the Tahoma font, wherein I have found that
Office/Win2K will then substitute the required Chinese/Japanese/Korean fonts
when required, even on a character by character basis.


You can also look in the Office 2K help files under "About multilingual
features in Office"

 

[User]

Access has an option to set the default font for datasheets.
There is also an option for dual-font or substitution font.

Try setting one or both to Tahoma

Not sure where the font settings for Controltips are
It may inherit from a Windows UI font setting such as Tooltips
(multilingual Controltips work fine on my system - I can even mix English,
Chinese, and Thai)

Your hit worked great ... when I saw ig chinese letters in the table all I
was seeing was little boxes (and currently see them, I don't know if that
could be corrected) , but when I put it into a form uising the the font you
recommended it workd fine.

One other question, do you have any hits on hou to get the controltip text
to display in the same foreign language?

George

If you are using Acc2000 or later and Win2K or later there is very little
that needs to be done.

For Win2K you have to install the required East Asian fonts for Chinese,
Japanese, and Korean.
by going to Control Panels->Keyboard->Input Locales.
The fonts will help you display and the input method editors will help you
enter data.

Acc2000 by default stores text as unicode (compressed) so there is no "code
page" stuff to worry about.
The Access textboxes must have their display font set appropriately (and
datasheets also).
One problem is that if you choose a Chinese font, it will not display
Japanese correctly, and vice versa.
(If you choose a Latin font like Arial, then it will display neither
Chinese/Japanese/Korean)

One solution is to install and use the "Arial Unicode MS " font (available
from the Office 2K cd/install options) which simultaneously contains symbols
for many of the worlds languages. Needless to say, this is a big font file.
[from MS]
"Note Because of its considerable size and the typographic compromises
required to make such a font, Arial Unicode MS should be used only when you
can't use multiple fonts tuned for different writing systems. For example,
if you have multilingual data from many different writing systems in
Microsoft Access, you can use Arial Unicode MS as the font to display the
data tables, because Access can't accept many different fonts."

Another way is to choose the Tahoma font, wherein I have found that
Office/Win2K will then substitute the required Chinese/Japanese/Korean fonts
when required, even on a character by character basis.


You can also look in the Office 2K help files under "About multilingual
features in Office"