force a leading zero in the integer

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

I would like to add a leading zero in my integer if there is single digit in
to a string.
Are there any functions to do the formating?

Your information is great appreciated,
 
I would like to add a leading zero in my integer if there is single digit in
to a string.
Are there any functions to do the formating?

Your information is great appreciated,
Click to expand...

You "can't" ADD a leading zero to an integer datatype field because
Access won't accept them. Access knows that 07 is the same integer
value as 7.
You can add leading zeros if the field is a text datatype field, i.e.
"07", or you can "Display" the Integer value with leading zero's by
setting the control's format property to:
00

7 will display as 07, 77 will display as 77, but the stored value will
still be just plain old 7.
 
Back
Top