Multiple currency symbols on form?

[Guest]

As an international business we have to work with various currencies. We buy
services in various countries and have to convert theses costs back to our
base currency (£ sterling) for quoting and billing purposes.
I have a currencies table that holds the currency names and exchange rates.
On my quotes form we can enter a cost figure (in the currency) in one field,
then use a combo in the next field to select the relevant exchange rate, and
the next field will show the converted cost in £ sterling. Then we add all
the various converted amounts together, add a margin and there's our selling
price.
All these monetary fields are set to "currency" type and by default they
acquire the £ sterling symbol, 'cos I am in the UK.
However, that is obviously not appropriate for the cost figures where we are
purchasing in (say) euros, or US dollars. We want the £ symbol only on the
converted amounts.
So, to the question: is it possible to display more than one currency symbol
at a time, within the same form. And if so, how???
Many thanks
CW

 

[John Nurick]

The standard "Currency" number format uses whatever format has been set
in the Windows Regional Settings control panel applet. But if you
explicitly set a number format on the text box it will override the
"Currency" format.

So one approach would be to set the Format property of the textbox to
this
#,##0.00
which will display the number with no currency symbol. (Presumably the
adjacent combo box is displaying the currency code.)

Or you could get fancy and set Format property t on the fly every time a
new currency is selected in the combo box. E.g.
GBP £#,##0.00
EUR €#,##0.00
JPY ¥#,##0

 

[Guest]

Thank you, John. I like the look of the second suggestion. I'll give that a
go. Thanks again.
CW