Pad a number with leading zeroes

[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

 

[Tom Lake]

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

Store it as a string then use

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

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

Tom Lake

 

[Steve Schapel]

Alan,

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