Monthly report and with month in title

  • Thread starter Thread starter charkey
  • Start date Start date
C

charkey

I am trying to run a monthly report where I can display the month name in the
title. I can get the value for the month (5 for May) to display but how do I
change that the the month name "May"? Can I use an array? Below is the
array I would like to use.
Dim qcmonth
qcmonth = Array(“Januaryâ€, “Februaryâ€, “Marchâ€, “Aprilâ€, “Mayâ€, “Juneâ€,
“Julyâ€, “Augustâ€, “Septemberâ€, “Octoberâ€, “Novemberâ€, “Decemberâ€)

Where and how do I have that to show up in the title?
 
If you have the month number in the report's record source or someplace,
simply set the control source of a text box to something like:
=MonthName([Month Number])
 
Back
Top