Currency field- can it be editable or dynamic?

[llpeters]

Hi All!

I work in a database that has several currency fields all set that way in US dollars. Maybe 1 out of 10 times I need to create a record where the currency would need to be displayed in euros, pounds, etc. Is there a way to make the fields editable so that I can ovverride the $ symbol only when I need to? Its not worth making the fields general since the majority of the time the value is $. Its also too clumsy to make a drop down box next to each field where you can select the currency symbol because there are MANY fields on the layout that display currency and its already a tightly structured layout. Any other ideas? Thanks! 

[comment]

If you mean can you format a field as currency and have the currency symbol calculated dynamically, the answer is no. You could do your own formatting, e.g. by auto-entering a calculated value.

[bruceR]

I take it these are not really currency fields. But they are, perhaps, price fields, that is, number fields, which may be entered in units associated with the currency. Do you ever need to aggregate these? For instance, generate totals? In which case you would NOT merely enter the currency symbol, but most likely require fields for net foreign price, currency type, exchange rate, and calculated USD. For instance. Just displaying the intended currency symbol within the field does not solve the whole problem.