How do I make a field zero filled in Access 2002

M

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"
 
D

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.
 
Top