Format(dteCurDate, "yy")

  • Thread starter Thread starter Leonard
  • Start date Start date
L

Leonard

I would like this to show up as "03" in my table but it
only shows up as "3". How do I force the zero to appear?

Any suggestions welcom.

Private dteCurDate as Date
dteCurDate = Date
[OrdNumYr] = Format(dteCurDate, "yy")
 
If OrdNumYr is a number field, then it will store the value as 3. ACCESS
drops off leading zeroes in such situations.

If you don't wish to change the field format to Text (which will retain
leading zeroes), then you will need to format the display of the number on
forms and reports, using the Format property of the control.
 
Thanks Ken
-----Original Message-----
If OrdNumYr is a number field, then it will store the value as 3. ACCESS
drops off leading zeroes in such situations.

If you don't wish to change the field format to Text (which will retain
leading zeroes), then you will need to format the display of the number on
forms and reports, using the Format property of the control.

--
Ken Snell
<MS ACCESS MVP>

Leonard said:
I would like this to show up as "03" in my table but it
only shows up as "3". How do I force the zero to appear?

Any suggestions welcom.

Private dteCurDate as Date
dteCurDate = Date
[OrdNumYr] = Format(dteCurDate, "yy")
Click to expand...


.
Click to expand...
 
You're welcome.

Leonard said:
Thanks Ken
-----Original Message-----
If OrdNumYr is a number field, then it will store the value as 3. ACCESS
drops off leading zeroes in such situations.

If you don't wish to change the field format to Text (which will retain
leading zeroes), then you will need to format the display of the number on
forms and reports, using the Format property of the control.

--
Ken Snell
<MS ACCESS MVP>

Leonard said:
I would like this to show up as "03" in my table but it
only shows up as "3". How do I force the zero to appear?

Any suggestions welcom.

Private dteCurDate as Date
dteCurDate = Date
[OrdNumYr] = Format(dteCurDate, "yy")
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top