Armageddon ;). How are you limiting an autonumber field to only 3 numbers?

AutoNumbers are Long Integers by default which can be up to 2,147,483,647.

Adam will the database go BOOM  :)

It won't be pretty Juan, I suggest getting the milk and bread and bunkering up, prepare for the worst ;).

Julian
It may sound silly, but why not make a small little test db with one table and a couple fields and try it?

Sometimes the best way to see if a thing works, or what happens if,  is just try it.

Scott check this out all jokes aside I did try it and I get a long and a Replication ID.  will not let limit the field to 3 at the table limit.  {1F1D1D77-A015-4EF7-96C9-6DF9698EAE1F} this is what a Replication  ID looks like not sure how to use this.. looks cool I will look it up later.  every new line has a diffrent number.  thanks for the sugestion now you saprked in me to go look at this.

LOL
V/r
Juan
LLNP

Juan you and I are saying the same thing.  I agree.
My point in the reply was to experiment. Try things out if you don't know how something will work or react.

I can't find it at the moment but a recent video discussed using Replication ID.  I'll keep looking and post when I find it.

Glossary: ReplicationID

Adam, Kevin, and Juan
I believe that Julian is using a custom ID field that Richard made a TechHelp for:  Automatic Record Numbering
If that is case Julian could have a circumstance where he could run out of numbers.

Julian - On the assumption that the above is true.  Running out of numbers would just cause an error. Because you have limited yourself to 3 you would just have to increase the width higher.
It isn't usually a problem increasing the allowable Field Size.  On the other hand reducing a Field Size can result in data loss or corruption if you already have data that exceeds the new value.  Changing data types can have an adverse affect as well.

You can't have an AutoNumber with field size 3. The options are Long Integer and Replication ID. Please clarify what you mean.

I have a department database which links via my accounts software as

dept code 3
dept name 60

department code is 0 to 999

in access the department autonumber goes 1 to 1000  not 0 to 999

when I go to import the detail back to the software package the import features fail due to 1000 being a 4 digit, however, I created another field Dept Number as the departments are now out by one digit.

Problem I have is now is I may be doing this wrong:

Access stock file displays depart field as 21 from the autonumber and in my accounts software the department number is displayed as 20.  Its all to do with the 0 being the first record number as 1.

just a thought that code may not be a number but a string, take a look and see

If you need 0 then you can't use an autonumber. Use a regular long.