date format

[Ivor Williams]

I have a report that uses a query as its data source. In the report is a
text box which uses the following as a Control Source ="Date:" & " " &
[Date]. This works fine except I can't get the format to display as Medium
Date. If I don't include ="Date:" & " " &, the date displays as I would
like. Is there a way to fix this?

Ivor

 

[Allen Browne]

Try:
="Date: " & Format([Date], "Medium Date")

If you have a reason to format the date like that, be sure to clear anything
you had in the Format property of the text box, and make sure the Name of
the text box is not the same as the name of your field.

 

[John Spencer]

Use the Format Function to format the date in the string

="DATE: " & FORMAT([Date], Medium)

Or

="DATE: " & FORMAT([Date], "m/d/yyyy")