IsNull not working

[pbaldy]

I suspect if you delete the input mask your error will go away. I've seen the same error, when I edit a textbox displaying a 4 digit year that has a 2 digit input mask. When you edit data, you have to follow the input mask. For me that has meant manually deleting the "20" portion of the year.

[RuralGuy]

You can create a fresh, new db and *import* just the problem forms and table structures without the data.

[vbjohn]

I think I found the problem. The input mask is 99/99/00 and the data that is coming to that textbox control is 99/99/0000.

[pbaldy]

The input mask...why didn't I think of that?

[aldridge_p]

That makes sense