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
|
|||
|
|||
Date Format
Hi,
In Access 2007, how can I show a date as Jan 08 when the date was selected as 01/01/2008 using the date picker tool? Is this possible. Regards John |
#2
|
|||
|
|||
Date Format
On Wed, 9 Jan 2008 19:35:33 -0000, John wrote:
Hi, In Access 2007, how can I show a date as Jan 08 when the date was selected as 01/01/2008 using the date picker tool? Is this possible. Regards John Set the Format property of the control to: mmm yy This will only affect the display. The value will still be 1/1/2008 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Date Format
Show it where? If in a text box, set the text box's Format property to mmm
yy -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John" wrote in message ... Hi, In Access 2007, how can I show a date as Jan 08 when the date was selected as 01/01/2008 using the date picker tool? Is this possible. Regards John |
#4
|
|||
|
|||
Date Format
Guys....
You are the best. Regards John "Douglas J. Steele" wrote in message ... Show it where? If in a text box, set the text box's Format property to mmm yy -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "John" wrote in message ... Hi, In Access 2007, how can I show a date as Jan 08 when the date was selected as 01/01/2008 using the date picker tool? Is this possible. Regards John |
Thread Tools | |
Display Modes | |
|
|