=IIf(IsNull([SyringeSize]), "N/A", [SyringeSize]) The result I get in my text field is "#Error"
S steady Jun 9, 2006 #1 =IIf(IsNull([SyringeSize]), "N/A", [SyringeSize]) The result I get in my text field is "#Error"
R Rick B Jun 9, 2006 #2 Just use the Nz function... =Nz([SyringeSize],"N/A") The field "SyringeSize" is a text field, right?
F fredg Jun 9, 2006 #3 =IIf(IsNull([SyringeSize]), "N/A", [SyringeSize]) The result I get in my text field is "#Error" Click to expand... Make sure the name of this control is not "SyringeSize".
=IIf(IsNull([SyringeSize]), "N/A", [SyringeSize]) The result I get in my text field is "#Error" Click to expand... Make sure the name of this control is not "SyringeSize".
