Adding text to the Control Source

[Robbyp2001]

Hello folks, after several frustrating hours, I'm almost on the point of giving up. Here is what I'd like to do in a Text Box on a report.

The text box should be set to date() but I need to change the format and to add additional text so that the box will display

Eg. "On this day, Tuesday 23 October 2012"

I managed to get the date part correct by entering =Format(Date(),"dddd dd mmmm yyyy") in the Control Source, but I cannot add the text "on this day" at the beginning. I just cannot seem to get the syntax right.

I know that this is a simple expression and I feel a bit silly having to ask for help but.......can someone help?





Regards

Rob

 

[plog]

="On this day, " & Format(Date(),"dddd dd mmmm yyyy")

 

[Robbyp2001]

Dear Plog, Wonderful! I'm sure that was one of the methods I tried. Obviously not. It worked perfectly. Doh!

Many thanks

Rob