How do I make a field zero filled in Access 2002

[mikecraw]

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.