Attention MS Access Aces 1

[macduff2]

hello,
I need some help with auto numbering. Is there a way to change the format from 1,2,3,4,5 etc.....to 000001,000002,000003,000004,000005 etc.....

I tried messing with some of the property boxes, but had no luck. Is a character that I need to add? like ie....' * # %

Thank you,

Colin

 

[dhookom]

There is no way to change the actual stored value. You can use the Format() function to display a variety of formats:

Format([YourFieldName],"000000")

Duane
Hook'D on Access
MS Access MVP

 

[macduff2]

thank you!