Different Currency's

[Modelstate]

I was wondering how I can make my Euro currency field into a currency field
in Dollars or Pounds.

 

[Steve Schapel]

Modelstate,

You would need to have the relevant conversion factor. Probably it
would be best for this figure to be in a table. And then you can use an
unbound textbox on your form or report to calculate the Dollar or Pound
equivalent of the Euro amount, by setting the Control Source property of
the textbox to something like this...
=[YourEuroAmount]*[DollarFactor]

Hope I have understood your question correctly!

 

[John Nurick]

If Steve's answer isn't the one you need, try setting the Format
property of the field, and of the controls you use to display it, to
something like this

"$#,##0.00;($#,##0.00)"