Currency format problem in report field

[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

 

[Fredg]

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

 

[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.

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

.