Why doesn't my expression work

[Guest]

=IIf(IsNull([SyringeSize]), "N/A", [SyringeSize])
The result I get in my text field is "#Error"

 

[Rick B]

Just use the Nz function...

=Nz([SyringeSize],"N/A")

The field "SyringeSize" is a text field, right?

 

[fredg]

=IIf(IsNull([SyringeSize]), "N/A", [SyringeSize])
The result I get in my text field is "#Error"

Make sure the name of this control is not "SyringeSize".

 

[Pat Hartman\(MVP\)]

If SyringeSize is numeric, you cannot store a text value.