Number Problem

  • Thread starter Thread starter PeteEHP
  • Start date Start date
P

PeteEHP

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
 
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.
Click to expand...

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.
 
ÄãºÃ£ºÎÒÓÐÒ»¸öÎÊÌâ²»¶®¡£ÇëÎÊÄãµÄÓʼþÊÇ´ÓÄÄÀï·¢À´µÄ£¿ÎªÊ²Ã´È«ÊÇÓ¢ÎÄ£¿
 
Back
Top