Display a message when no value is stored in a field.

[Kage]

I have a number field that is displayed on a report. There are times when there will be no value stored in the field. When this is the case, I want to display a text message instead of leaving it blank. I use this field for calculations so I cannot change it to a text field. Is there a way to do this? I was playing with the following formula, but get the error message ' #ERROR '

=(IIF([Volume] Is Null,"Data Not Available",[Volume]))

 

[Atomic Shrimp]

I think it might have to be:

=(IIF(IsNull([Volume]),"Data Not Available",[Volume]))

But I'm not sure.

Mike

 

[Kage]

Thanks for your help, but unfortunately it did not work....

I will keep trying.

:-(

 

[Alexandre]

If I understand well, you use that field for calculation and therefore would like to store 0 when no value is is entered but let the user see a message instead. If this is the case, use 0 as default value for your field/control, and in format: #;;"message"

 

[llkhoutx]

Try

=(IIF([Volume] * "" = ""),"Data Not Available",[Volume]))

IsNull works funny sometimes.

 

[Kage]

Unfortunately that will not work. The problem is that we do not know what the value is because it was never reported. The fact that the issue was reported at all indicates that the value is greater than zero.