Displaying 0 (zero) as first character in date

  • Thread starter Thread starter denilynn
  • Start date Start date
D

denilynn

When typing January 17, for example, as 0117 in my table,
how can I get the 0 to show? When I tab to the next field,
only the 117 displays. Thanks in advance for your help!
 
-----Original Message-----
When typing January 17, for example, as 0117 in my table,
how can I get the 0 to show? When I tab to the next field,
only the 117 displays. Thanks in advance for your help!
.
Click to expand...
Format the field:
Format(XXX,"mmdd")
 
Which Field type are you using to store the data?

It looks like you use one of the Numeric Field to store
date value. Consider DateTime type.

HTH
Van T. Dinh
MVP (Access)
 
Is there a way to use a Date/Time type, but have the date
display as military time without the colon? I would like
1/17 to display as 0117 for example. Thanks!
 
I couldn't get this to work. Which data type should I be
using? Any additional information would be great! Thanks!
 
Is there a way to use a Date/Time type, but have the date
display as military time without the colon? I would like
1/17 to display as 0117 for example. Thanks!
Click to expand...

Yes; use a Date/Time field and set its format property to

mmdd
 
Back
Top