displaying currency in a text box 1

[daz321]

I have a report that contains the following:
"...the calculation of their weekly contribution is [FAC_ASSESSMENT] per week. Payment..." where [FAC_ASSESSMENT] is a value in a table. I have defined the column in the table as type currency, but when i view the report the value has the trailing zero missing (i am assuming that the the value is converted to a string). Is there any way to show the value as intended??

 

[SgtJarrow]

Define the field as a text field and use the following for the currency sections:

Format([FAC_ASSESSMENT], "Currency&quot

or

Format([FAC_ASSESSMENT] , "$#,##0.00&quot

Either one will work, but the second one gives you the ability to leave off the $ sign if you want, etc...just a little more precise if you want something different than the normal. It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[Steve101]

Robert,
I dont understand the advise to define the field as a text field. From Daz's description of this field, its clearly intended as a currency field, so the problem is not in the data type, but probably some other formatting characteristic associated with the field or display control.

Daz, I think you might want to check out some of the FORMAT related properties associated with the table and/or report (and/or query, if the report is bound to a query). Some of these properties could be inherited from a 'predecessor object', hense checking back all the way to the table's field property definitions.

Cheers,
Steve

 

[SgtJarrow]

Steve,
Sorry about that...not reading everytthing to the letter....I read that as:

defined the field

and did not even see the in the table part...


daz,
Steve is right. Check from your display backwards, all the way to the table. Look for somewhere where the data type might be getting changed from Currency to Text or something.

Either way, you should still be able to use my above method to get the display the way you asked....


Robert goes and put a big sticky over his forhead...."Read the whole question!"
It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[Steve101]

No worries Robert. I sometimes need one of those stickies myself,
Cheers,
Steve