Export (0) Print
Expand All

NewValues Property

Office 2000

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

                 

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.

SettingDescription
Increment(Default) AutoNumber field values increment by 1 for new records.
RandomAutoNumber 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.

Show:
© 2014 Microsoft