IIF not working

[teiben]

HElp, I've searched all thought this board, looking for an idea of what I'm doing wrong. I have a text field [test] on a report. This is often empty, null. I want the report to show "Data not entered" instead of the blank the report is showing.

I've tried:

=IIf(IsNull([test]),"Data not entered",[test])
=IIf([test]="isnull","Data not entered","")
and it seems every other possible combination. HELP

 

[teiben]

So how would you write it that way?

 

[sportsguy]

=IIf(IsNull([test]),"Data not entered",[test])

this syntax is correct,
however, if the control has a NUMBER format,
then there will be an error,

NULLS are always best handled with ZEROS if
the control is referencing a number field.

The other possibility is that the control name is conflicting with the
query field name on the report.

sportsguy