Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attention MS Access Aces 1

Status
Not open for further replies.

macduff2

Technical User
Apr 4, 2012
5
US
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
 
There is no way to change the actual stored value. You can use the Format() function to display a variety of formats:
Code:
Format([YourFieldName],"000000")

Duane
Hook'D on Access
MS Access MVP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top