L louiserome Registered User. Local time Today, 02:00 Joined May 22, 2001 Messages 14 Sep 18, 2002 #1 is there a way to preset the autonumber to have numbers that look like 0001, 0002, 0003 and to use up the zeros as they increase??
is there a way to preset the autonumber to have numbers that look like 0001, 0002, 0003 and to use up the zeros as they increase??
P Pat Hartman Super Moderator Staff member Local time Yesterday, 21:00 Joined Feb 19, 2002 Messages 47,936 Sep 18, 2002 #2 You can use the Format() function or the format property of a control to show leading zeros in a number. Format(YourField,"0000")
You can use the Format() function or the format property of a control to show leading zeros in a number. Format(YourField,"0000")
