Default Value for Access Table Ignored (121865)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Query
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.
REFERENCES
For more information about Setting A Default Value For A Field,
choose the Search button in Microsoft Access 2.0 Help and type:
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB121865 |
---|
|