[AccessD] Currency symbols

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