=IIf(IsNull([hphone]),"","h: " & [hphone])
So within one text box I want to have home, cell and work phone. If the field is empty, show nothing. With IIF i've figured how to do that for one. How do I code it for all 3? I've tried:
=IIf(IsNull([hphone]),"","h: " &...