Format a Date Text Box As 2010-02-28


G

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
 
Ad

Advertisements

J

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

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
 
Ad

Advertisements

J

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top