Default Value for Access Table Ignored

CAUSE

Microsoft Query does not recognize the default value of a field in a table that was created in Microsoft Access. This behavior occurs using either the Microsoft Access 1.0 data source, or the version 2.0 data source. In Microsoft Access, when you design a table, you can assign a default value to a field. For example, for a Yes/No field type, you can assign the default value 1, which translates to a value of Yes for this field. If you enter a new record in this table, and you don't enter a value in this field of Yes/No data type, the value Yes appears by default.

However, if you enter a new record in this table in Microsoft Query, and you don't enter a value in this field of Yes/No data type, the value 0 appears by default. The value 0 appears even if you have not assigned a default value to this Yes/No field type. Additionally, for any other field types that are assigned a default value in Microsoft Access, the field remains empty if you enter a new record but leave this field blank in Microsoft Query.