Preceding zeros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lilbomshl - 16 Dec 2004 01:13 GMT

how do I keep preceding zeros in a field, i.e. an autonumber field. I want
my numbers to start at 001, but I want the preceding zeros to show.

Reply to this Message

Douglas J. Steele - 16 Dec 2004 02:00 GMT

Numbers don't have preceding zeros when stored: that's formatting, which
really has nothing to do with the value. If you want 3 digits, set the
format for the field to 000

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> how do I keep preceding zeros in a field, i.e. an autonumber field. I want
> my numbers to start at 001, but I want the preceding zeros to show.

Reply to this Message

lilbomshl - 20 Dec 2004 04:09 GMT

Douglas, thank you SO much for your help!!

> Numbers don't have preceding zeros when stored: that's formatting, which
> really has nothing to do with the value. If you want 3 digits, set the
[quoted text clipped - 3 lines]
> want
> > my numbers to start at 001, but I want the preceding zeros to show.

Reply to this Message