Number formatting

[John]

Hi

How can I format numbers from 1 to 10 such that if number is single digit
than a 0 is appended on the left to make it two digit?

Thanks

Regards

 

[Pete D.]

You have to keep it as text or leading zero will disappear.

 

[fredg]

Hi

How can I format numbers from 1 to 10 such that if number is single digit
than a 0 is appended on the left to make it two digit?

Thanks

Regards

In the Format property of the control, write
00

 

[John]

Sure, how?

Thanks

Regards

You have to keep it as text or leading zero will disappear.

 

[John]

I need to convert an integer variable to a string. Sorry I was not clear.

Thanks

Regards

 

[fredg]

I need to convert an integer variable to a string. Sorry I was not clear.

Thanks

Regards

Well you did ask how to 'Format' the value, not how to convert it to a
string!
Format only affects how the value is displayed.

=Format([NumberField],"00")
will be a string.

Wouldn't it be simpler to just change the Field from a Number datatype
to Text datatype field?

Update YourTable Set YourTable.[NewTextField] =
Format([NumberField],"00")

 

[Rick Brandt]

Hi

How can I format numbers from 1 to 10 such that if number is single
digit than a 0 is appended on the left to make it two digit?

Thanks

Regards

=Format(NumberValue, "00")