Good day all.

I have a data base, and I have a table, a column called "Price"
for this column, i want it to be a currency, so i selected my "Data type" as currency.
but i want to change the currency symbol! I only get the dollar sign $
I would like to change it ot the Euro Symbol € how do i get this done ?

Thanks in advance.:D

In the table you can set the field format from Currency to Euro.

David

You are better to have Currency in your Table rather than creating confusion as to what Currency the Price should be.

Simon

In the table you can set the field format from Currency to Euro.

David
And how Do I do that May I ask?

You are better to have Currency in your Table rather than creating confusion as to what Currency the Price should be.

Simon
Huh?

You mean Type in the € Symbol each time??

I prefer to just type in the digits
eg. " 3.65 "
and then when I leave the cell, it turns to " €3.65 "

See Attachment for how.

Huh?

You mean Type in the € Symbol each time??

I prefer to just type in the digits
eg. " 3.65 "
and then when I leave the cell, it turns to " €3.65 "

In the table, you can define the DATATYPE as Currency, but then the FORMAT you can define as EURO:

http://downloads.btabdevelopment.com/screenshots/ceuro.png

See Attachment for how.

:D - funny how we both had the same idea :)

Great minds think alike :)

Post #2 gave the solution, why did it take so long to resolve?

Post #2 gave the solution, why did it take so long to resolve?

Yes, and sometimes pictures help more than words.

Thanks guys!.. Forgot to say thanks