[AccessD] Currency symbols

Hi Doug

You could use:

=IIf(CustCurrency="USD","$","€") & Format(POValue,"#,##0.00")

/gustav


>>> dbdoug at gmail.com 26-11-2009 17:46 >>>
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