autonumer (1 Viewer)

L

louiserome

Registered User.
Local time
Today, 16:49
Joined
May 22, 2001
Messages
14
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
Today, 11:49
Joined
Feb 19, 2002
Messages
43,371
You can use the Format() function or the format property of a control to show leading zeros in a number.

Format(YourField,"0000")
 
You must log in or register to reply here.

Similar threads

P
How to Sequential Numbering that includes Month Year and resets every year
Replies
17
Views
926
apr pillai
apr pillai
J
Insert Records with VBA and get new autonum value - different variants and possible problems
Replies
5
Views
346
Josef P.
J
B
Proper way to setup a Yes/No/Null field in table and form?
Replies
18
Views
435
Pat Hartman
P
R
Solved Restricting Entry to Numbers Only in Text Field
Replies
11
Views
529
RogerCooper
R
T
Solved Autonumbering in tables
Replies
17
Views
724
Pat Hartman
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom