Currency format problem in report field

  • Thread starter Thread starter Cheint1
  • Start date Start date
C

Cheint1

I have the following in a field of my report query.

PULSE_COMMITTED: Nz([New Table]![SumOfAmount Obligated],0)

The property has been set to currency, but it will not
display the way currency would on my report. However, it
is only in the detail section of my report that it is like
this. In the footer (where the sums are added up and
displayed) the format is correct. Why is this? Any idea
of how I can force the currency format on the report?


THANKS IN ADVANCE,
Clay
 
Thank You - works like a charm.


-----Original Message-----
In the report, in an unbound control:
=Format([Pulse_Committed],"Currency")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Cheint1 said:
I have the following in a field of my report query.

PULSE_COMMITTED: Nz([New Table]![SumOfAmount Obligated],0)

The property has been set to currency, but it will not
display the way currency would on my report. However, it
is only in the detail section of my report that it is like
this. In the footer (where the sums are added up and
displayed) the format is correct. Why is this? Any idea
of how I can force the currency format on the report?


THANKS IN ADVANCE,
Clay
Click to expand...


.
Click to expand...
 
Back
Top