[AccessD] Currency symbols

I've just had a request to change a purchase order database to allow
printing of Euro currency as required.  My first crack at this is to do the
following in each currency text box on the printout:

=iif(CustCurrency="USD",format(POValue,"$#,###.00"),format(POValue,"€#,###.00")

(I hope the Euro sign came through in the second format string)

This is going to be a bit tedious - does anyone have a better method? Some
reports will have to both both EUR and USD currencies, so I can't set
anything before the report prints.

Doug Steele