Pad a number with leading zeroes

A

Alan T

I have a number would like to pad with leading zeoroes so that to make up as
3 digits string.
eg.

1 --> 001
12 --> 012
999 --> 999
 
T

Tom Lake

Alan T said:
I have a number would like to pad with leading zeoroes so that to make up
as 3 digits string.
eg.

1 --> 001
12 --> 012
999 --> 999
Click to expand...
Store it as a string then use

Right("000" & [Yourstring], 3)

where Yourstring is, of course, the name of your string.

Tom Lake
 
S

Steve Schapel

Alan,

Set the Format property of the applicable controls on your form and
report like this:
000
 
Top