Hi all,

Does anybody know how to format the autonumber of a field in Access?

What I want is a 5 digit Autonumber, whenever I select autonumber as the field datatype it always shows the actual number i.e. number 6 is 6....

I want 00006

Is that possible

Thanks for any help
Steve