0 number

[Loi]

Hi,
I have a table which has a ID field. For ID field, I
choose NUMBER type. However, whenever I type in 00256, It
will become 256. Please show me what I should do so that I
can keep 00.

Thank you
Chi Huynh

 

[Rick B]

00256 is the same as 256. When using numbers, the leading zeros are
irrelevant. You don't ask someone if you can borrow "zero zero five
dollars" do you? Just as with a calculator or adding machine, zeros are
trimmed from the start of a number.

If those zeros are important you can use formatting in your reports and
forms to include them, or you can change the field to a text field.

Rick B

 

[PC Datasheet]

Have you ever seen a number that looks like 00256? 00256 is not a number!
Change the data type to text.