Microsoft KB Archive/115898

= ACC2: AddNew Method Uses Table Default Values =

Article ID: 115898

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q115898



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
The documentation for the AddNew method in Microsoft Access version 2.0, states the following for when you add a new record using the AddNew method,

  This method sets the fields to Null (the default values specified for a   table-type Recordset in Design view of the corresponding table aren't   used).

This statement is incorrect.



RESOLUTION
The documentation should state the following:

  This method sets the fields to either Null or to the default value specified in Design view of the corresponding table.

When you add a new record using the AddNew method, the default values in a table are used since default values are enforced at the database-engine level in Microsoft Access version 2.0. In Microsoft Access version 1.x, default values are not used when you add a new record using the AddNew method.

