Applies To
Table.
Description
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.