#Error

[Robert L.]

In a text box on form, how do hide this #Error message?
My form is based on a query and sometimes no information
is found (which is okay). But I want the text box to be
blank not display the the "#Error" Message.

I do not want to change the text box to a combo box. Is
there a way to hide this message? Thanks for any help.

 

[Wayne Morgan]

The value being returned by the equation is Null. You need to handle the Null in the
equation.

Check the Nz function in the Help file. You may also be able to use an IIF function.

Example:
varTest=Null
Nz(varTest, "")
will return a zero length string if varTest is Null but will return varTest if it isn't
null

Nz(varTest, 0) will return zero if varTest is Null

Iif(IsNull(varTest), "", varTest)
This would be similar to the first Nz above.