Date format in Reports

Question

My database was developed in Access 2003 and now I've migrated to Access 2010. In a report, I want to display the date in the format of "Month", e.g. January. I had the following format but now it's not working, "=Format$".

Answer 1

You haven't answered my first two questions, but I take it from your reply that the control is named Date of Rotation, in which case you have a circular reference.  You have two options:

1.  Rename the control to something else, e.g. txtDateOfRotation.

2.  Bind the control to the Date of Rotation column and set its Format property to mmmm.

Both depend on the answer to my first question being yes.

Answer 2

Date of Rotation is a text box in the Report.

Answer 3

1.  Is Date of Rotation a column in the report's recordset, and if so, is it of date/time data type?

2.  If the above is the case, what happens if you bind a control to the column and set the control's Format property to mmmm?

3.  What is the name of the control?  If it is also Date of Rotation then the expression is a circular reference to the control, which would produce an error.

Answer 4

Dear Ken, thanks for your advise. I write the expression on the format indicated, =Format([Date of Rotation],"mmmm"), and it continues to give an error.

Do you think it has to do with the Properties?

Answer 5

Your expression would show the date in the format November, 2013 for instance.  You do not need to specify the first day of the week or first week of the year arguments; they relate to week numbering.  The following would be sufficient:

=Format([Date of rotation],"mmmm, yyyy")

But you seem to be saying you want the month name only, in which case:

=Format([Date of rotation],"mmmm")