Access Date Format 1

[DMHCCI]

I am running Office XP Pro with XP pro OS.

I would like to be able to enter a date as mm/dd/yy and have it assume mm/dd/yyyy.

For example 060503 would be entered and 06/05/2003 would be displayed.

I do not see a date format that allows this to happen.

Do you have a work around?

 

[scriverb]

Use this as the Input Mask: 99/99/00;0;_

Use this as the Format property: mm/dd/yyyy

This should do it for you.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[DMHCCI]

Thanks - I learned something

 

[scriverb]

I am glad that I could help you. Thanks for the Star.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???