How to store number 0?

  • Thread starter Thread starter HM
  • Start date Start date
H

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
 
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.
 
Thank a lot Doug :)
That what I want, using format of 00000 then it is work.
Best regards,
HM
 
Back
Top