Issues with Text Box formats and expressions

[AndrewsPanda]

I am creating a letter template in the report section of Access. My first problem is even though I am updating the "Format" of the field to display a certain thing and updating this across all forms and reports. When I put in the following expressions the information reverts back to a default format.



Eg. For date I have chosen Long format. (Friday, 7th October 2011). It is showing up correctly on the form. However on the report it is showing up as 7/10/2011.
I am using the expression =Trim([Course Date]) & "."

Second issue:

How do I have normal text, then insert an expression like the one above and continue typing in the one text box.

The course date is =Trim([Course Date]) & "."

The course date is Friday, 7th October 2011.

[pbaldy]

You shouldn't need the Trim function, as there wouldn't be any spaces in a date/time field. If that doesn't get your default format back, use the Format() function, with the appropriate arguments:

="The course is on " & Format([Course Date], "Long Date") & "."

Check out the Format function in help for a more complete description of what you can do for formats.

[AndrewsPanda]

Once again thank you so very much for your help. I have created it now and it works great. The project is almost done =)

[pbaldy]

No problemo.