I have a simple IIF statement set up in a text box and it is not working. The table it refers to has all fields defined as text.
Code:
=IIf([EmpName]="","Unassigned","Assigned to " & [EmpName])
For some reason it always returns the false value. I have tried this as well as
Code:
=IIf([EmpName]=Null,"Unassigned","Assigned to " & [EmpName])
and
Code:
=IIf([EmpName] is null,"Unassigned","Assigned to " & [EmpName])
None have worked, they all return the false condition. What am I doing wrong? Thank you in advance for your help.