Date Format

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
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
Click to expand...

Set the Format property of the control to:
mmm yy

This will only affect the display. The value will still be 1/1/2008
 
Show it where? If in a text box, set the text box's Format property to mmm
yy
 
Back
Top