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