I am setting up a db with Autonumber as the primary key in several tables. I am creating the autonumber through a form entry and I am having problems with the formatting. I need the autonumber to be 5 digits and always positive. I set my field property in my table to the following:
Field Size: Long Integer
New Values: Random
When I created the first two records in this table through my form the first autonumber that was 1248127065 and the second was -7090466874. Two problems that I need to fix:
1. Autonumber number needs to be 5 numbers.
2. Autonumber should never be negative.
I am working in Access 2007.