Leading 0's in number field

[bill1one]

I have an ID field in my table and 0's are crucial in the ID. Many IDs start with a 0, such as 0120743. Whnever I enter an ID, the leading 0's disappear, so 0120743 becomes 120743. Is there a way to stop that from happening?

 

[lupins46]

You have to use a text field to store numbers with leading zeros.

 

[bill1one]

That's no fun. Thanks.

 

[ZmrAbdulla]

If you are not using any calculation with this number then you can set the DataType = Text in the table design.

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[ZmrAbdulla]

I am too late on reaching you.. Sorry

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[lespaul]

That's no fun.

standard rule of thumb is: if you aren't going to perform calculations then don't store it as a number, make it text.

How often do you add up all the SSN in your tables? Or ZipCodes? Are you going to be performing calculations on these ID numbers?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design