Number formatting

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
Click to expand...
In the Format property of the control, write
00
 
I need to convert an integer variable to a string. Sorry I was not clear.

Thanks

Regards
Click to expand...


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")
 
John said:
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
Click to expand...

=Format(NumberValue, "00")
 
Back
Top