I have created a report to be produced once a month and would like the month and year noted in the main title of the Report. The date required is entered by the user on a input selection form and is available as a global varaiant for the report.
I have placed an unbound textbox in the report header and intended to give this textbox controlsource a combination of a text string and a re-formatted date ie "Detailed report for " & format(SpecificDate, "mmmm yyyy"). Problem is that this only creates an error when the report prints. I have also tried creating code to put the information in the textbox but I get an error message stating that Access cannot give the object a value.
I have placed an unbound textbox in the report header and intended to give this textbox controlsource a combination of a text string and a re-formatted date ie "Detailed report for " & format(SpecificDate, "mmmm yyyy"). Problem is that this only creates an error when the report prints. I have also tried creating code to put the information in the textbox but I get an error message stating that Access cannot give the object a value.