How to restrict a randomly assigned autonumber to 4 digits?

[Delta223]

Hi,



I am using an autonumber set to random but do not like the length of the numbers it chooses. It also chooses negative numbers sometimes (-23827439) I would like to restrict the autonumber to display 4 digit positive numbers. Is there any way to do this?

Thanks

[pkstormy]

You should let the autonumber do it's auto-increment without manipulating it in any way. Then have a number type field which you can then manipulate.

The only time I've seen autonumber values such as (-23827439) is when replication was used. One big reason I avoid replication. If you do use replication, it's very important not to try and manipulate the autonumber values. MSAccess uses this 'hit and miss' random type method to avoid duplicated/orphaned records which I've personally never liked.

[Delta223]

I'm still fairly new to this application so I'm not sure what replication is but I will take a look, thanks