I have 5 fields on a form that get input into an Access database. The fields are set to Integer and not required and no default value. The form validates for number. If I put a number in the add new goes fine but if I leave them blank I get a type mismatch error. I thought if the field was not required in the database no value was fine. What am I missing here?