Create a title for a Report

[PeterG]

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.

 

[burrcm]

Put a textbox (hidden) called say dateentry1 in the detail section with the control source set to =[Enter Date], then reference this textbox in the report header with = [dateentry1]. Then it should work OK.

Chris B

 

[PeterG]

Access report

Thanks, that did it!