 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 20050 number
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 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 > Hi, > I have a table which has a ID field. For ID field, I [quoted text clipped - 4 lines] > Thank you > Chi Huynh Have you ever seen a number that looks like 00256? 00256 is not a number! Change the data type to text. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > Hi, > I have a table which has a ID field. For ID field, I [quoted text clipped - 4 lines] > Thank you > Chi Huynh |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.