TYPE MISMATCH error in form

[gleeson]

Had a form working good. Then on all occasions get Error 'TYPE mismatch' in Validation rule. I have check and re-checked properties in both form and underlying table. There are no validation rules (that I have assigned anyway) anywhere. I deleted the 'form' and made a new one (using the wizard), but the problem persists. Any ideas anyone?

 

[SomeGuy]

This has happened to me on occasion. It normally occurs when I write some new code. It will suddenly pop out of nowhere when other people start using it.

You are likely correct that you haven't assigned any validation rules but Access does some of this for you.
For instance, in the field properties for text fields in your tables, it sets the "Allow Zero Length" strings to No. If you then use the following code:

If [blahblahblah] happens Then
[field] = ""
End If

you will get an error of Type Mismatch because that condition is not allowed to happen.

This might not be your problem but you might want to look into it.

[This message has been edited by SomeGuy (edited 12-24-2000).]

 

[Blkblts]

I get this if I field in one table that is a number and field that I am relating it to in another table that is maybe a date or text...