Storing Foreign Currency Symbols

[LisaConsult]

I have an application in Access 2000. The application needs to be changed so
that it will handle other currency symbols other than just $. I have created
a database table which I plan to store the 3 character abbreviation; Currency
symbol (text field type); Position of Symbol (before or after amount), etc.
The user will select the currency they are reporting in and I just need to
use the proper symbol in the reports. I have been able to add the Euro, Yen
and other symbols to the Symbol field in the database by using the unicode
equivalent. However, I'm not able to enter the unicode equivalent of the
Korean Won (Alt+8361) to get its symbol. I have downloaded the Arial Unicode
MS font, but I'm not sure how I can set my table to use a specific font(or if
that is even the correct approach). Any ideas are appreciated. Thanks.

 

[William Wang[MSFT]]

Hi,

Typically we can get the Korea Won currency symbol through these step:

1. Do one of the following:

a. For Microsoft Windows XP, click Start, point to All Programs, point to
Accessories, point to System Tools, and then click Character Map.
b. For Microsoft Windows 2000 Click Start, point to Programs, point to
Accessories, point to System Tools, and then click Character Map.
Note If Character Map is not available, see Windows Help for information
about how to install a Windows component.

2. In the Font list, select "Arial Unicode MS font".

3. Select the "Advanced view" check box.

4. Verify that "Unicode" is selected in the "Character set" list box, then
type 20A9 in the "Go to Unicode" text box.

5. The Korea Won currency symbol should be selected at this time. Click the
Copy button.

6. Switch to your Access table, paste the symbol there.

You may also want to copy the symbol from the following web page:

http://www.answers.com/won

NOTE This response contains a reference to a third-party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there. There are inherent dangers in the use
of any software found on the Internet, and Microsoft cautions you to make
sure that you completely understand the risk before retrieving any software
from the Internet.

Please let me know if the suggestions help.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[LisaConsult]

William,

Thanks for the insight to the character map. However, it's simply pasting
into Access 2000 (a Text (5) field ) as a square (like an unrecognized
character rectangle). I'm running Access 2000 (9.0.6926 SP-3). Any thoughts?

 

[William Wang[MSFT]]

Hi,

Let's perform the following steps:

1. Launch Access 2000, click Options command on the Tools menu.
2. On the Datasheet tab, choose 'Arial Unicode MS' from the Font list.
3. Click OK.

This time you should be able to see the charater correctly.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[LisaConsult]

That worked! Thanks. If I am distributing this application via MDE, do I
need to make sure all users have the 'Arial Unicode MS' font? or do they
have to have the datasheet set to that font in order to see the character?

 

[William Wang[MSFT]]

It's my pleausre to help

The answers to your additional questions are Yes. They need to have the
'Arial Unicode MS' font installed and configure to use that font in the
Datasheet tab.

Sincerely,

William Wang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=/international.aspx.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.