show 0.00 instead of ""(blank)

[simeybt]

I have a report with a list of different results on it. some of the fields do not contain any values. i want the field to show up as a 0 or £0.00 instead of ""(blank field).

Thanks

Simon

 

[lupins46]

Set the format for each textbox:
£#,##0.00;(£#,##0.00)

or whatever.

 

[simeybt]

That only formats the result if there is a value in the text box. If the query returns no value then nothing at all is shown in the text box.

Simon

 

[TonyJollans]

Hi simeybt,

There are (up to) 4 semicolon-separated formats you can provide and the fourth is for nulls, so you could try ..

[blue][tt];;;£0.00[/tt][/blue]

If you want to use other formats for other values just enter them in the appropriate place; to combine with lupins' example ..

[blue][tt]£#,##0.00;(£#,##0.00);;£0.00[/tt][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[simeybt]

Thanks for the responses guys, i got a fix for it before i got tony's reply. i'll post it here incase someone has the same problem. i got round my problem by using the IIF() and IsNull() function. here is and example

=IIf(IsNull([CSI 2ND LINES.SumOfQuantity]),0,[CSI 2ND LINES.SumOfQuantity])

Simon