Formatting lost on report field

[Three]

Hello

My report has column of money data... the text field formats are all set to
currency. Before I reworked the report this displayed the figures in $x.xx
format which was good. Now it doesn't do that even though it is still set to
Currency... the totals fields in the footer are still working fine, as is
the rest of the report....

How can I force these fields back to displaying the data in currency format?

Ta

 

[Allen Browne]

Are these calculated fields? If so, I'm guessing that Access does not
recognise them as numbers, and so is not able to format them as Currency
even though the Format property of the text boxes is set to Currency.

If they are calculated fields, the solution may be to typecast the
calculation. Details in article:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My report has column of money data... the text field formats are all set to
currency. Before I reworked the report this displayed the figures in $x.xx
format which was good. Now it doesn't do that even though it is still set to
Currency... the totals fields in the footer are still working fine, as is
the rest of the report....

How can I force these fields back to displaying the data in currency

format?

 

[Three]

Yep... that sorted it... I was doing the typecast on the report side and it
wasn't working... when I did it in the query it worked fine...

Cheers