[AccessD] Currency symbols

Thanks, Gustav.  That will save me some typing..

On Thu, Nov 26, 2009 at 9:02 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>