Report Detail Section - formating text box

[stevemccauley]

I have a date/time text box in my report detail section. I want to format it to read
March 5, 2002, so I put in the equation:

=format([Date], "mmmm d, yyyy")

but I get an error message, this has happened before, is it not possible to format text boxes in the detail section of a report?

 

[Rich]

Just put mmmm d"," yyyy as the format on the property sheet for the text box, no need for a function

 

[Sohaila Taravati]

If you do this it will work.
Format([Date],"mmmm dd\,yyyy")
Sohaila

 

[Rich]

Is the property sheet no longer supported in A2k or is a Function more efficient?