#ERROR on IIF when True ???

[Steve_Bache]

Anyone throw some light on this ? It's probably quite simple but I just can't see it.

I have a report showing many detailed records per page. I'm using a straighforward IIF -

=IIf([Open]=0 And [Completed]=1,"No","Yes")

However if the condition is True I get #ERROR in the report field. If False I correctly get "Yes" output.


I'm using the same IIF statement successfully in another report, but each page shows just 1 record ?

Cheers

Steve

 

[Steve_Bache]

Sorted

Sorted this myself by just deleting the control and re-adding text box. Don't know what I did differently this time but at least it now works !