Hi,

I am creating a database of private equity funds. I want to have a currency field for an input entitled fund size. However, I need to be able to display whether the size of the fund is in dollars or euros. How can customize a number/currency field to allow me to input the correct currency symbol?

Thanks

Do you mean like this: €

Hold down Alt and type in 0128 to get that character. You can get any standard character that way. Use the Character Map (Accessories -> System Tools) and you can see all the characters and their related ASCII value, which is what you're typing in. Then use the Format property to make the Euros use that symbol and US dollars with the standard dollar sign as necessary.

Thanks for the reply. However I was not asking how to code in the symbol for Euro that is easy and is contained in the help section of access. What I am asking is modifying the property field to allow for either dollar or euro input, when the field is of type number or currency. The best that I can see is that it is not possible. Access like much of its programming is archaic and static. That is it refers to whatever your system as set. Alternativey it treats euro as a different input among the currency choices. I was trying to see if I could type in a syntax that would allow me that flexibility. So to answer your question, your response, while appreciated, did not answer my question.

Mmm... I don't think that formatting is the issue.

Depends why you want to store both currencies and what you are going to use them for. If you have one field in a table that is mixed $ and €, you're not going to be able to do any maths on this in a consitent way. Have you considered caputuring the numeric data in an unbound text box in a form and the currency type in another? Then you can store the value in whichever of two underlying fields is appropriate. Or you could use a conversion and hold it both as dollars and euros.

In any event, I tend to hold currency just as numbers and only apply formatting in a form or report. You can concatenate the appropriate currency symbol with the numeric value, or display the two in adjacent text boxes.