MS Access Text Box Control Source Uses an Input Box--one input, all report pages...
Posted on 2006-07-18
I created a basic report in MS Access 2003. The footer (a text box) on the report is typed in each time the report is generated using an input box. It is working fine, except that it asks for input (footer text) for each individual page of the report instead of asking for it once and printing it on all of the pages of the report.
In the control source for the text box, I have the following:
=InputBox("Enter the string you want to print in the footer below or leave blank if you don't want anything to print:","Footer Text","")
Can anyone help? I'm not very advanced in my Visual Basic skills so more detail is better than less...