Symptoms
A “Type Mismatch” error is generated when a control is bound to a fieldwith an incompatible type, but the Error object is not populated when it isexamined in the Data Control Error event.
Resolution
This is a limitation of the Data Control in Visual Basic version 4.0. Whenthe DAO generates an error, the Error object is cleared when the Errorevent for the Data Control is fired.