OK, here goes.
Super Access rookie question #1:
How do I make a number display as "001" and not "1" in datasheet view? The field type is number not text.
OK, here goes.
Super Access rookie question #1:
How do I make a number display as "001" and not "1" in datasheet view? The field type is number not text.
Hi -
Set the format property of the text box on the form to "000" (without the quotes).
John
There is a format property for the table fields in table design view as well, any the setting is the same - "000", without the quotes.
I must point out that entering data directly into your tables like that is not a very efficient use of MS Access, since you have very limited ability for data validation. Is there any particular reason why you are not using a form?