How do I make a field zero filled in Access 2002

[Guest]

I am using access 2002 and I have to change a field that is an 5-6 digit
account number to a zero filled account. such as "123456" to "0000123456"

 

[Douglas J. Steele]

Change it from a numeric field to a text field. Just because it's got
numbers doesn't mean it has to be a numeric field: it shouldn't unless
you're going to do arithmetic with it. Once it's a text field, the preceding
zeroes will stay there.

 

[Joseph Meehan]

I am using access 2002 and I have to change a field that is an 5-6
digit account number to a zero filled account. such as "123456" to
"0000123456"

Normally you would not change the data, rather you would chance the
format. Plan on changing the format in all the forms and reports etc. where
the number is displayed.

In the case of the table you can use 0000000000 in the format property
of the field definition.