UCase with Now() function

[Guest]

I have a text box on report whose control source is the Now() function and
the format property is mmmm dd", " yyyy.

I want the date to appear in capital letters on the report. I have tried
the UCase function and could not get it to work. I could not use the ">" in
the format propery because it is already set to mmmm dd", " yyyy.

Thanks for any help.

 

[John Spencer]

You should be able to use

= UCase(Format(Now(),"mmmm dd, yyyy"))