How can I force a number to be 3 digits? If someone enters a 1 can I have Access store 001.
R Ripper Apr 2, 2007 #1 How can I force a number to be 3 digits? If someone enters a 1 can I have Access store 001.
K KARL DEWEY Apr 2, 2007 #2 "001" is not a number -- it is text. Change you field to text and set the format.
G Geoff Apr 3, 2007 #3 Ripper said: How can I force a number to be 3 digits? If someone enters a 1 can I have Access store 001. Click to expand... look at formatting it as it's displayed, not when it's being stored (assuming your data is always a number) store 3 change the formating of the control showing it to 000 displays as 003
Ripper said: How can I force a number to be 3 digits? If someone enters a 1 can I have Access store 001. Click to expand... look at formatting it as it's displayed, not when it's being stored (assuming your data is always a number) store 3 change the formating of the control showing it to 000 displays as 003
