Format a Date Text Box As 2010-02-28

[GeyikBaba]

I am coming back to Access after a couple of years off, and have forgotten
more than I knew.

At any rate, I have an app being used in US, Japan, and UK from a Citrix
server in USA. I would like to use a date type field in the database table,
but format the text box displaying the date as yyyy-mm-dd. I've found that
everybody gets it, and in any case they are not typing dates, just reading
them.

Is there a way to format a texbox to show the date as yyyy-mm-dd. I've
thought about just using a text field in the database, then just formatting
the contents as above and displaying them.

By the way, is this forum available via a browser like IE or Firefox? If
so, what's the URL?

Thanks
Mike Thomas

 

[John W. Vinson]

Is there a way to format a texbox to show the date as yyyy-mm-dd. I've
thought about just using a text field in the database, then just formatting
the contents as above and displaying them.

You'll hate this... because you answered the question yourself.

Set the Format property of the textbox (form or report) to

yyyy-mm-dd

It will accept input in any recognizable date format; if you type 2/20 into
the box it will display as 2010-02-20.

 

[GeyikBaba]

You've got to be kidding me! I've been away from Access for a couple of
years, but to miss something like that is pretty bad.

Thanks for the pointer.

Mike Thomas

 

[John W. Vinson]

You've got to be kidding me! I've been away from Access for a couple of
years, but to miss something like that is pretty bad.

The user interface doesn't make this obvious: it "helpfully" offers some
standard formats such as Short Date, but it's not clear that you can enter any
valid format property, just by typing in a text string. And there are a LOT of
valid formats!

Good to have you back in the best database development environment going!