Display Numbers

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

Using Access 2000
I have a table that contains a field with a Data Type
of "number" - When I enter the number 00055, it's
displayed 55 - How & where do I change this so the number
is entered 00055?

Thank you
 
Using Access 2000
I have a table that contains a field with a Data Type
of "number" - When I enter the number 00055, it's
displayed 55 - How & where do I change this so the number
is entered 00055?
Click to expand...

A number IS A NUMBER - it's actually stored as binary bits, not as
zeros and fives. 00055 and 55 are simply two ways of displaying the
same numeric value, and they are stored identically in your table.

If you won't be doing mathematical operations on this "number", I'd
suggest storing it in a Data Type of Text, length 5, and use an Input
Mask of 00000 to force entry of five digits. If you want to keep it as
a Number field, set its Format property to 00000 to display (although
not store!) it with leading zeros.
 
Change the Data Type to Text, and use an Input Mask!
Search Access Help for 'mask' and select:
'Input mask syntax and examples'
--
Hope this helps!

Pat Garard
Australia
apgarardATbigpondDOTnetDOTau

"One look is worth a thousand rumours."
Wen Hou, Warring States Period.

"Look twice!"
Pat Garard, 2003.
 
Back
Top