Spelling out dates

T

Tony Williams

If I have a field that is called "txtperioddate" that is a date field
formatted as dd/mm/yyyy how can I create a text field called
"txtperiodlabel" that spells out the month and year for example if
txtperioddate is 02/10/2004 I want it to create the value of txtperiodlabel
as October 2004
Thanks
Tony
 
I

Ian King

Tony,

Try setting the control source of the text box 'txtperiodlabel' to:
=format(txtperioddate,"mmmm yyyy").

I think that should do it.

Ian King
 
Top