auto increment field

[cjamps]

Is it possible to have an autoincrement number field with an input mask of 080000 so the first number would be 080001 and so on. Also to code it that the fives should not be used. For example 080005, 080010.

 

[thingssocomplex]

Hi I am fairly new at this myself however I can assist open the table you want the autonumber to appear in select design view click select the ID field, in the bow below were it states format type in the number you want to start from i.e 080000 please be aware the first record will be 080001. Hope this helps

 

[neileg]

Not practical to use an autonumber. These can adopt strange behaviours and can only be guaranteed to be unique (well, mostly). If your number has meaning, then you will need to allocate it yourself using VBA.