Unable to Format Textbox to currency in Report

[jukus]

I have a report that is based on a query. It Contains info from 4 queries.

It has I Total Due a Total Paid and a Balance field. All are calculated fields.

When I get to my report I can format the Total Due and the Balance Textboxes allow me to format to currency, but the Total Due will not allow me to select anything for format. This is a head scratcher to me.

The original fields the totals come from are all currency and the 4 qureis I set to currency.

Any idea why this is happening and is there a way to force a currency format if I can not get it working.

Thanks for any advice on this.

 

[GolferGuy]

My first thought is that the Total Due field is actually a label. But probably not, so the next thought is a corupped text box. Create another text box and see if you can use the currency format for it. If so, use it and delete the one that does not want to do as you tell it.

 

[Brianwarnock]

Did you use the NZ function on the field in the query?
If so you will have a string which cannot be currency, use Val to revert back to a number

Val(NZ(your field or expression))

Brian

 

[jukus]

Yes I did use the nz function. The Val() worked like a charm. Thanks. I appreciate the help.