Textbox IIF statement not working

[jgelpi16]

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.

=IIf([EmpName]="","Unassigned","Assigned to " & [EmpName])

For some reason it always returns the false value. I have tried this as well as

=IIf([EmpName]=Null,"Unassigned","Assigned to " & [EmpName])

and

=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.

[ajetrumpet]

two substitutes you might want to try just on first glance of this:


instead of "Assigned to " & [EmpName] ... use "Assigned to '" & [EmpName] & "'"

instead of [EmpName] is null ... try either isnull([EmpName]) or [EmpName] = null

[jgelpi16]

Thanks for your help. isnull([EmpName]) worked perfectly.