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!

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)"

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.