Date field in a Report

[Angel-888]

Hi,

I have a report where I added text then a date field based on a Table. In the table I have specified the "Co_ContractEndDate" for input mask as dd/mm/yyyy, however the format to display as dd mmmm yyyy. This works in the Form and in the report as it's own control text box, however when I merge the field with some text the formating changes.

My report text box is as follows:
="The Program Period for this Program will finish on " & Co_ContractEndDate] &"."

The output in Print Preview is:
The Program Period for this Program will finish on 30/06/2013.

I would like to show it as:
The Program Period for this Program will finish on 30 June 2013.

As a work around I have aligned the date field with the label field to get the outcome but as it is a sentence I would like to add a full stop at the end.

Can someone help in how to show this text box in design view?

 

[Galaxiom]

Put this in the format property of the control.

dd mmm yyyy\.

 

[Angel-888]

Great thanks.

It worked when I added to the control only ie the date field. When I tried to make it all a sentence with the additional text (="The Program... " & [datefield]) it still reverted back to the short date context with the full stop at the end. I have just left the text as a label field and the date in its own control.

Thanks again, I will keep that tip up my sleave.

 

[Galaxiom]

Try this ControlSource:

="The Program... " & Format([datefield], "dd mmm yyyy\.")