custom date format mmm/yy

[Guest]

Hi, is there any way in a Report to customize the date displayed in the
report to be mmm/yy? Or even mmm/yyyy would be better for me than the
options Access seems to offer in their reports.

All I see there is Short Date, Medium Date, Long date - they all take up so
much space in a densely packed report.

Thanks,
Harold

 

[John Spencer]

You can use your own formats

In a control's format property, enter
mmm/yy or mmm/yyyy or mm/yy

For a discusson of the formatting characters, put your cursor in the format
property and press the F1 key for help.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks so much, I had no idea it would be so easy!
Harold