How to store number 0?

[HM]

Hello,
I have a table with the field (ProjectID) is set to
primary key.
My manager want to enter a this field with start number
00001 to 99999. But when I enter for 00001 then all of the
number zero dissapear.
How can I prevent it? Change this field to Text? My boss
he do not want it !
Please help, Thanks in advance.
HM

 

[Douglas J. Steele]

Are you doing arithmetic with the project number? If not, then it should be
stored as text.

If you're forced to keep it as a number, use a Format of 00000 to display
it.

 

[HM]

Thank a lot Doug
That what I want, using format of 00000 then it is work.
Best regards,
HM