Uppercase date format

[purple_chicken]

I have a form where i input a date in a short date format. The data is saved in the table in short date format but when i want to print the selected record from a report I want the date to be in a long date format (which is no problem) but i also want it to be in uppercase.

the standard long date format puts it like 23 November 2005
I want it like 23 NOVEMBER 2005.

Any Ideas?

 

[KenHigg]

ucase(myDatefld)

???

 

[purple_chicken]

to put where? in the report textbox properties or in a vb on open command as neither work.

 

[KenHigg]

I would do it in the reports underlying query...

(This may not work - it was just an idea )

 

[Pat Hartman]

Put this in the controlSource of the report control. Make sure to change the Name property of the control (Other tab) so that it is different from the name of your date field.
=UCase(Format(YourDate, "Long Date"))