M
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
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