If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format a Date Text Box As 2010-02-28
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 |
#2
|
|||
|
|||
Format a Date Text Box As 2010-02-28
On Sat, 20 Feb 2010 15:16:16 -0500, "GeyikBaba" wrote:
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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Format a Date Text Box As 2010-02-28
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" wrote in message ... On Sat, 20 Feb 2010 15:16:16 -0500, "GeyikBaba" wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Format a Date Text Box As 2010-02-28
On Sat, 20 Feb 2010 17:01:53 -0500, "GeyikBaba" wrote:
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! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|