NewValues Property

NewValues Property

See Also                  Applies To

You can use the NewValues property to specify how AutoNumber fields increment when new records are added to a table.

Note   The NewValues property applies only to AutoNumber fields.

Setting

The NewValues property uses the following settings.

Setting Description
Increment (Default) AutoNumber field values increment by 1 for new records.
Random AutoNumber field values are assigned a random Long Integer value for new records.

You can set this property in the table's property sheet in table Design view by clicking the General tab in the Field Properties section.

Remarks

When you replicate a database, AutoNumber field settings are set to Random to ensure that new records entered in different replicas will have unique values.