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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forcing a zero digit to appear

Status
Not open for further replies.

lm0304

Technical User
Jan 16, 2002
12
0
0
US
Hello everyone,

I need some assistance. Can anyone give me direction on how to force Autonumber to give me two digit places before a single digit number when counting from 1 - 9, ie: 001, and then a single digit place before a double digit number, ie: 010.

Any help would be great!!!! Thank you.
 
Hallo,

Autonumbers are always just long integers, if you want to display them in a particular way in a form or table field, you can use the format property (with a string of "000")
In code use the format$ function with the same string.

- Frink
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top