Date formatting in a report

[Jaspal]

Hi,

Hope someione can help. I have a report with a text box that returns the curent date in a text box by just placing Date() in the control source. Which returns the date as; 13/03/2006 - which it should. However i require the date to be outputted a as 13 March 2006. Does anybody know how i can achieve this

Many thanks for your help

Jas

 

[Rich]

Change the display format on the property sheet for the control to
"dd/mmmm/yyyy"

 

[Jaspal]

thanks,
cant believe it was staring me in the face and was that easy

Cheers