[AccessD] Currency symbols

One thing to remember is that you can't use a variable in a property expression, but you could create a property of the report and use it to return the variable or create a function in the report to return the variable.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Monday, November 30, 2009 9:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Currency symbols

Thanks, Charlotte, I'll try that
Doug

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

> Doesn't have to if you use code.  In the Open event of the report, 
> populate a module level variable using the call to the function.  Then 
> use that variable to populate the individual fields or format the 
> individual currency values.  If you're using Format anyhow, it should be no slower.
>
> Charlotte Foust
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com