Date Format

[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

 

[fredg]

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

 

[Douglas J. Steele]

Show it where? If in a text box, set the text box's Format property to mmm
yy

 

[John]

Guys....
You are the best.

Regards

John

Show it where? If in a text box, set the text box's Format property to mmm
yy