Microsoft KB Archive/121865

= Default Value for Access Table Ignored =

Article ID: 121865

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q121865



SYMPTOMS
In Microsoft Query, when you create a query using a Microsoft Access data source, default values assigned to fields in the table are not displayed when you add records to the table.



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.

