Dates and times in report

[Malcy]

Hi
I am producing a sort of mail merge report for job applications.
I have set up a query to collate data for a report. One field is date and one is time. I have set the properties in the query to long date and medium time. This is because I want the "letter" to say e.g. The interview is on 29 August 2004 at 11:00 AM.
I have created the relevant textbox in the report as follows:

="The interview will take place at " & [strInt1] & " on " & [dtmInt1D] & " at " & [dtmInt1T] & " . Please report to the reception desk 15 minutes before your interview is due to take place."

When I go to print preview the date is shown as 29/08/2004 and the time is shown as 11:00:00.
I clearly need to call a format from the report rather than relying on the format the query is feeding it.
Given I am calling these fields inside a textbox, as opposed to them being individual textboxes (with properties) in their own right, how do I do it?
Any thoughts or help greatly appreciated.
Best wishes

 

[KenHigg]

="The interview will take place at " & [strInt1] & " on " & format([dtmInt1D], "mm/dd/yyyy") & " at " & format([dtmInt1T], "hh:mm") & " . Please report to the reception desk 15 minutes before your interview is due to take place."


???
ken

 

[Malcy]

Thanks again Ken
That worked a treat. I hadn't realised one could be quite so devious in a textbox. All I needed to do was to change the date format to dd mmmm yyyy to satisfy our little UK date idiosyncracies!
Appreciate the help
Best wishes