How Can I Modify the currency symbol programmatically

[migo702000]

Hi everybody
I'm from Egypt
my Question is How can i Modify the currency symbol programmatically By access 2007??
The Following At t. Depends on Choose Currency Type then typing amount
to get numbers in words ..
i want after choosing Currency Type and typing the munber
Modify the currency symbol programmatically
as Example
جنيه مصرى ===> 18000.00 ===> 18000.00 ج.م.
دولار امريكى ====>18000.00 =====> $18000.00
AND SO ON..
hope i clear the subject
Best regards

[RuralGuy]

You may be able to modify the code in this link to suit you needs.

[migo702000]

You may be able to modify the code in this link to suit you needs.

i'm sorry sir this link doesn't Satisfy my request because my At t. already converting num. to words ..
i mean the field contains numbers how can i change the cur. symbol To suit with the cur.type which i select from the above combo box as follow:

As example

when i select US DOLLARS from combo box then i type the number (1000)-as example - in the next field then press enter the number converts to $1000.00
or
when i select EURO from combo box then i type the number (1000)-as example - in the next field then press enter the number converts to €1000.00
or
when i select Egyptian Pounds from combo box then i type the number (1000)-as example - in the next field then press enter the number converts to EGP 1000.00
and so on..
best regards

[RuralGuy]

OK, now I understand and I'm afraid I do not have a solution for you. Maybe someone else knows.

[dcrake]

What you may consider is adding a table that contains the currency character in one field and the id in another then when the user selects the currency type it goes away and get the relevant symbol. You would have to have the currency field as a double though.

The only issue is you cannot concat this to the value as it would turn it into a string. You would need to place it next to it as a lable or a caption.

David

[migo702000]

thank for all of you.
regrades