Dates in text strings (1 Viewer)

[Robbie]

My field [LetterDate] in table 1 is defined as DATE/TIME Formatted as: DD MMMM YYYY..
When my query is run it updates this field in the table with todays date i.e 04 January 2001. Works fine!!
On a report (in letter format, based on another query which selects this field) I have an unbound text box with the control source as the following text:

= "I refer to our letter dated " &[LetterDate]& "concerning your account."

On execution of the report it always gives me the following.

I refer to our letter dated 04/01/01 concerning your account.

Can someone tell a newcomer to access, what i need to do to get it back in the long date format on the report. I have tried allsorts but nothing seems to work..

Many thanks in advance.

 

[Neal]

I had to do something similar yesterday. There may be an easier way.

I set a variable called TheDate

TheDate = Format(Me![LetterDate], "Long Date")

Then I used the variable instead of the field name:
"I refer to your letter of " & TheDate & "blah blah blah."

 

[Robbie]

Many Thanks !
Now working perfectly.