L
Leif
I have an expression type conditional formatting using Access 2003. The
expression references a function that returns a value. The expression is the
following:
CalcEmpDuration([EmployeeID])>36
CalcEmpDuration is a public function in a module. EmployeeID is a field in
the recordset query for the form (part of the query, but not bound to a field
on the form). The conditional formatting works fine, except when I change
the record then press the escape key. At that time I get a series of pop up
messages boxes that say:
"Invalid Object or object no longer set"
I've tried displaying the query directly, making a change, and then pressing
escape. I do not get any errors. Also, on the form if I remove the
conditional formatting I don't get errors. So the problem is definately
related to the conditional formatting.
Any suggestions? Thanks.
expression references a function that returns a value. The expression is the
following:
CalcEmpDuration([EmployeeID])>36
CalcEmpDuration is a public function in a module. EmployeeID is a field in
the recordset query for the form (part of the query, but not bound to a field
on the form). The conditional formatting works fine, except when I change
the record then press the escape key. At that time I get a series of pop up
messages boxes that say:
"Invalid Object or object no longer set"
I've tried displaying the query directly, making a change, and then pressing
escape. I do not get any errors. Also, on the form if I remove the
conditional formatting I don't get errors. So the problem is definately
related to the conditional formatting.
Any suggestions? Thanks.