Off the top of my head, I believe you have to specify "00000" in the format
section of the table design.

HTH

Jamie,

You can force your numeric fields to display leading zeros in forms, reports
and queries by using:

    Format([MyNumberField], "0000")  ' which will get you a 4-character
number with leading zeros

However, you cannot store the data in a number field in your table that way.

You can get your number field to increment with the addition of a new record
by making the field an AutoNumber type.  But, be aware that the purpose of
an AutoNumber field is only to provide a record identifier with nearly 100%
guarantee of uniqueness.  There is no guarantee of consecutiveness, as
AutoNumbers are not re-used; deleting a record or starting to create a new
record will leave 'holes' .

If you must have a number-like field in your table which stores leading
zeros, the Data Type must be text.  And, if you must have consecutiveness
guaranteed, you'll need to create and code your own custom numbering system.
This is a frequently-discussed topic and if you do a search on "custom
numbering system in Access" in http://groups.google.com  you will get
numerous 'hits'.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX