Monthly report: display month as text in Header

[iamrah]

Hello,
I have a report that displays records on a monthly basis. The report is based on a query, and the specific month is selected as a number (1-12) by using the following:

Field: Month([ProtocolDate])
Criteria: [Choose a month from 1-12]

So, if I want the report to display only the Protocols for January, then I select 1 when prompted.

I'm attempting to display the month (selected as a number via query) as text in the Header. For example, when I select 1 to display the report for January, I would like for 'January' to be displayed in the Header.

I have an unbound Textbox in the header, but I'm not sure how to get it to display the month selected. I have tried =Month([ProtocolDte]) in the control for the textbox, but it will only display the number of the month.

This is probably an easy fix, but my inexperience is not allowing me to figure it out. Thanks in advance for any help.

Frank

 

[pbaldy]

Try

=Format([ProtocolDate],"mmmm")

 

[iamrah]

Worked great! Thank you kind sir!