Default value in report

  • Thread starter Thread starter Pradeep
  • Start date Start date
P

Pradeep

Hi,

I have a report which displays this data. All the data is at present
0. But in the report it shows nothing. But if have a number other than
0 it shows that number. I want to display "-" sign if the value of
textbox in the report is 0.

How can this be done ?
 
First, is the value 0 or Null?

One of the following should work for the control source of the textbox on
the report.

=Nz([FieldName], "-")
=IIf([FieldName]=0, "-", [FieldName])
 
Back
Top