Opening Report

[keithcrooks]

Hi guys,

I have a report that I would like to be able to open, but when opened I would like it to ask me to say type in a Title to put at the top of the page.

It needs to be nothing fancy at all even just a box that opens when I open the report that i type the title into and that info is put into my report.

many thanks in advance..

 

[SOS]

Use a FORM and name it frmReportTitle for the input and then name the text box

txtReportTitle.

Then open the report in design view and add a text box to the Report Header and set the control source to:

=Nz(Forms!frmReportTitle.txtReportTitle,"")

And then as long as the form remains open, the title will be there.

 

[keithcrooks]

Many many thanks once again

 

[SOS]

Glad we could help.