Five Characters

[Bill]

I have a field title "Emplyee ID"
Date Type is "Number"

Some of the numbers have zeros at the beginning.
Example: 00042
The entry in the table is 42 and I want it to be 00042.
Note: There will always be 5 numbers.
How do I fix this problem?

I'm using Access 2000

Thank you

 

[MacDermott]

You could use a Text datatype.
Leading zeros are always removed in Number type fields.

Alternately, you could set the Format property of the textbox where it is
displayed to something like "00000".

HTH
- Turtle