conditions to equal "#Error" in Text Box

[Marrek]

I want to create a macro which changes the value of a
text box to zero, when the message #Error is displayed in
the text box.

My text box is unbound, so i can manually delete and
replace the #Error with a 0, but i want to have this done
automatically with a macro.

My problem is, I cannot create a conditional statement
which is true when the #Error is in the text box

[text box] = "#Error" is false!
IsNUll[Text Box] is false
Not IsNull[TextBox] is true

So, it appears that the #Error message has some sort of
value, but is not the text which appears!

The value #Error is coming from a field on a report which
is also #Error. this is because the query has is not
returning any records.

Any ideas would be greatly appreciated

Mark

 

[Ken Snell]

Trap the error in the query so that you can display a value of your choosing
in place of the error value.

Please provide more info about why the error value occurs in query so that
we can suggest some ways to trap that error.