If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Number Problem
I have a number 01410000. I have a table and a form setup. Now i want acess to display this as a default value. For some reason it strips the leading zero off. Any reason why? I tried hard coding and setting a default option. It strips the leading zero off. Thanks Pete ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Number Problem
On Wed, 9 Jun 2004 08:46:34 -0500, PeteEHP
wrote: I have a number 01410000. I have a table and a form setup. Now i want acess to display this as a default value. For some reason it strips the leading zero off. Any reason why? I tried hard coding and setting a default option. It strips the leading zero off. A Number *is a number* - numerically, 01410000 and 1410000 and 0001410000.000000 are merely different ways of *displaying* the same 32-bit binary numeric value. If this is an identifier, and you won't be doing calculations with it, I'd suggest using a Text type field with an Input Mask of 00000000 to force entry of eight digits. If you have some good reason to store it as a number, set its Format property to 00000000 to display (but not store) leading zeros. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|