B
Box666
I am trying to use "Iif" on a form and relating it to a date box. I am
trying to say that if the date box is blank then show a "2" in the
unbound text box
=iif([NewDate]=" ","2","3")
It keeps showing as "3" even when there is no date in the box. The date
field has an input mask set as the standard short date
"00/00/0000;0;_", is this producing the error, or is there something
else that I need to do.
Bob
trying to say that if the date box is blank then show a "2" in the
unbound text box
=iif([NewDate]=" ","2","3")
It keeps showing as "3" even when there is no date in the box. The date
field has an input mask set as the standard short date
"00/00/0000;0;_", is this producing the error, or is there something
else that I need to do.
Bob