Format Problem

[Guest]

I am having trouble formatting a date to show up in Caps. My goal is to have
this print out in a label on the report:

MONTHLY STATS FOR JANUARY 2007

But all I get is

MONTHLY STATS FOR January 2007.

Here is what I am working with:

label21.Caption = "MONTHLY STATS FOR " &
Format(Forms!frmIDC_Header_Info!Stats_Range, "mmmm yyyy")

The date information comes from the "DateFrom" field on a form where the
user inputs the date range for the report. I tried putting the ">" at the
end of "mmmm yyyy", but that didn't work.

Any help would be appreciated.

 

[Guest]

Just use the ucase() function

label21.Caption = "MONTHLY STATS FOR " &
Ucase(Format(Forms!frmIDC_Header_Info!Stats_Range, "mmmm yyyy"))

Daniel

 

[Guest]

That was too easy. Thanks. Works perfect.

Just use the ucase() function

label21.Caption = "MONTHLY STATS FOR " &
Ucase(Format(Forms!frmIDC_Header_Info!Stats_Range, "mmmm yyyy"))

Daniel