Convert DatePart value to decriptive text

[BonCourage]

I have a report title with a textbox that I want to display the current month's name.
I have set the control source as =DatePart("m",Date()).
I have also used Month(Date()) and Month(Now()).
All three of these yield the value 7, which seems correct because it is now July.
However, I want to display "July", not 7.
If I enter mmmm under Properties>Format it yields "January", not July.
If I enter =DatePart("mmmm",Date()) I get an error.

Can someone clarify what is wrong here?

 

[thornmastr]

?format(date,"mmm&quot
Jul

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[BonCourage]

Robert,

THANK YOU!!!! It worked. As is always true, the simplist code is often the best.

Thanks again!

BonCourage