Adding user notes to a report

[LHWC]

How do I add user inputted text to a report?

Thanks in advance.

 

[KenReay]

A little more information worul be helpful

Is the inputted information saved in a table?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[LHWC]

No, I just would like the ability to add some notes to a report. The text doesn't have to become a record. It would just print on the report.
Ideally, upon opening the report, a msgbox opens that says, "Would you like to change the Global Specs?" It should display the current text and allow the user to edit it. An OK cmd button closes the msgbox and loads the new text into the textbox on the report.
Thanks for the help!

 

[KenReay]

Hi
Easiest way to do this, create a form (MyForm), include on the form a button to run the report (wizard will guide you through this). Include also a text box control (txtNotes)

In the report in the onformat event of the section which contains the notes put code like so

If IsNull(Forms!MyForm!txtNotes) Then
Else
txtGlobalSpecs = Forms!MyForm!txtNotes
End if

Note Form must be open when report runs for this to work
I am assuming txtGlobalSpecs is the name of the control in the report

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK