[AccessD] Currency symbols

I wonder if that would slow down a large report with lots of currency
values?  I will experiment.

Thanks
Doug

On Mon, Nov 30, 2009 at 8:37 AM, Charlotte Foust <cfoust at infostatsystems.com
> wrote:

> An even better way is to create a function the returns the correct format
> (however you determine that, system settings or data) and make that part of
> the format string.  That avoids umpteen Iif statements and works in code or
> in the properties grid.  Just call the function each time you use a
> formatted currency value.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Thursday, November 26, 2009 9:03 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>