Autonumber

  • Thread starter Thread starter Yolanda Yarde
  • Start date Start date
Y

Yolanda Yarde

Hi:

Is there anyway I can setup autonumbering to use a specific numbering
fomula? For example to put 2 zeros before the numer 1, 2, 3 and so on.

Thanks
 
In the Format property of the field, add 000. That will
show three digits, but still only save the real number.

i.e. 10 would display as 010, but still save as 10.

Chris Nebinger
 
Thank you. That worked fine!



Chris Nebinger said:
In the Format property of the field, add 000. That will
show three digits, but still only save the real number.

i.e. 10 would display as 010, but still save as 10.

Chris Nebinger
Click to expand...
 
yes, you can format the field for display purposes, but...
generally speaking, it's not a good idea to use an autonumber for a field
that users are going to see/use. for instance, formatting 1 to show as 001
will only work until you reach 1000 records, then the formatting has no
effect.
also, an autonumber keeps a hard sequence. once a specific number is
assigned to a record, it will not be used again, even if the record is
deleted. so you may end up with "gaps" in the number sequence in your table
records.
and keep in mind that an autonumber field just keeps going and going - to 2
billion+ and then negative 2 billion+ (according to another answer to a
posted question along these same lines).
suggest you review your need for a 3 digit number and consider an
alternative to using the autonumber field.

hth
 
Back
Top