Custom Date in Report

[Johnny Drama]

I have a report that pulls date from a date field with the current format being short date, or 12/13/11. I would like the report to show the date as mm/yy. Is that possible to do?

Thanks!

Access 2007

 

[pbaldy]

Sure; check out the Format() function.

 

[Johnny Drama]

Okay...I get how to use the format function after looking at it, but where in the report would I place that? In the format property for the control? When I try to do that it starts adding quotes all over the place...

 

[Johnny Drama]

scratch that. got it figured out. thanks for pointing me in the right direction!

 

[pbaldy]

No problem!