Displaying 0 (zero) as first character in date

[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!

 

[Charles]

-----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!
.

Format the field:
Format(XXX,"mmdd")

 

[Van T. Dinh]

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)

 

[denilynn]

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!

 

[denilynn]

I couldn't get this to work. Which data type should I be
using? Any additional information would be great! Thanks!

 

[John Vinson]

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!

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

mmdd