Date - change to long format?

[fraser_lindsay]

Hi,

This shodul be a quick, easy one for somebody. Despite my search efforts I can't find how to convert my date format to long format in my text box.

I have a text box in which the control source =Date()

This works and displays the date, but I want a different format e.g.

1 January 2009 and not 01/01/2009.

How do I do it?

 

[boblarson]

Set the text box's format property to

"d mmmm yyyy"

 

[fraser_lindsay]

Thanks Bob.

I have also just realised how stupid I actually was. Just found the 'long date' format option as well, I obviosuly was looking with eyes closed.

I think I need more coffee or maybe work on something else for a while.