Placing a notes section in a report

[lugnutmonkey]

I would like to place a section on my report that allowsme write notes on a report before it is printed. I am trying to think of thebest way to go about doing this. I have been using a Label with a 2pt border;the problem with this is that it requires the user to go into layout view toadd notes.

Does anybody have a solution to this dilemma that wouldn't require the user togo into layout view?



Any and all suggestions will be greatly appreciated

[SoftwareMatters]

You could just add an unbound text box to the form where the report is opened and then add a text box to the report which reads from the textbox on the form.

[lugnutmonkey]

This method does work. However it requires me to save the form in order for the text to show up on the report. I would prefer if the text showed in the report without saving.

Is this possible?

[SoftwareMatters]

No, you shouldn't have to save the form if you follow this method:

WIth the form in design view: place a textbox on your form called TestBox then save and close.
With the report in design view: place a textbox on your report and in the ControlSource for the textbox put =[Forms]![FormName]![TestBox] and then save and close.

Now try entering some text into the form's textbox and then click the button to open the report.


Note: you need to change 'FormName' to the actual name of your form.

[lugnutmonkey]

This does work when I have the notes section on the form that calls the report. However, I would like the the notes to be controlled from a pop up form that is called on from the report. This way the user can review the report and then add notes that they see applicable before printing.

When I try to use the pop up form it will not save or show the text that is put into the text box. Is there perhaps a VBA code that I could use that would solve my problem?

[SoftwareMatters]

The only way that I can see this working is if you closed and then re-opend the report from the pop-up form with the notes box on.
Something like this: have a button that says 'Save notes before printing' or something and then when clicked it closes the report and opens it again (the users won't see this happening if you turn screen repaint off and on) but the notes will now appear on the report.

[lugnutmonkey]

I knew it was a stretch to get this kind of thing to work. I take your advice and give it a shot.

Thanks for the help!

[amrut]

You can use an Inputbox also. Place a text box in the report say txtNotes and set its controlsource to =GetNotes()
Put this code in the report

Function GetNotes()
GetNotes=InputBox("Enter the notes for  the report " & vbNewLine & "For Ex. This are report notes", "Enter notes")
End Function

[lugnutmonkey]

Amrut, the code works nearly perfectly, Thnak you. How would I have the code be called by a button click?

[lugnutmonkey]

I ask this because when I use the code the input box constantly pops up. I would like to have it so that the input box only pops up if you click a button.

[amrut]

To use it on button click, set the control source of report's text box to Form!YourFormName!yourTextBoxName where yourTextBoxName is a text box on the form. Enter the notes in the text box and then open the report using the command button.

There are other ways also to accomplish the above.