date format

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

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
 
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.
 
Use the Format Function to format the date in the string

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

Or

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