Formatting Date Field in Report

  • Thread starter Thread starter Con Giacomini
  • Start date Start date
C

Con Giacomini

I have an Access 2000 report which is actually a letter. In the report I
have a date field to print the full month, day, year;
formatted as mmmm d", "yyyy. This works fine.

My requirement is to add a period to the end of this field as it is the end
of a sentence in the report. I have tried using a label with the period in
it but because the month names are not the same length the period shows in
different places on the report.

I modified the query the report is based on to include the period; Due Date:
[DateField]&"."
This does work but it does not hold the mmmm d", "yyyy format, instead it
changes the format to mm/dd/yy.

Is there a solution to this problem?

Con Giacomini
 
Con said:
I have an Access 2000 report which is actually a letter. In the report I
have a date field to print the full month, day, year;
formatted as mmmm d", "yyyy. This works fine.

My requirement is to add a period to the end of this field as it is the end
of a sentence in the report.
Click to expand...


Add the period to the format:

mmmm d", "yyyy"."
 
Back
Top