Month to return in Capital Letters

[Alex Motilal]

Hi everybody
When I use the Date Syntax: =Format$([Date_Field],'mmmm yyyy'), the month returns in Small letters. eg., January 2010. I want the month to return in all capitals as JANUARY 2010. How to do this?
Thanks.

[RuralGuy]

Try:
UCase(Format([Date_Field],"mmmm yyyy"))

[Alex Motilal]

Thanks a lot. It worked.

[RuralGuy]

You're welcome. Glad I could help.