report with a memo box

[SylvieB]

Hello All
I’m using Access 2007. Is it possible to create a report with a memo box
section for users to fill out? The info on the memo box does not need to be
retain in the DB; once the user fills out the info, the report gets printed.
I just don’t want to create a form and then create a report based on the form
to print it.
Any suggestions?
Thank you very much

 

[fredg]

Hello All
I¢m using Access 2007. Is it possible to create a report with a memo box
section for users to fill out? The info on the memo box does not need to be
retain in the DB; once the user fills out the info, the report gets printed.
I just don¢t want to create a form and then create a report based on the form
to print it.
Any suggestions?
Thank you very much

Sorry, that is not do-able.

I assume you need just one memo to print out on the report (not a
different memo for each record in the report).
Create an unbound form
Add a text control.
Name this control "txtMyMemoData"
Name the form "frmMyMemo"

You can add a command button to open the report from this form:
DoCmd.OpenReport "ReportName", acViewPreview
Me.Visible = False
Save it.

Add an unbound control to the report.
Set it's control source to:

=forms!frmMyMemo!txtMyMemoData

When ready to run the report, open the form and enter the memo
information.
Then open the report by clicking the command button on the form.
The form will hide and the data in the form will print out in the
report's control.
Close the form when the report closes from the Report's Close event:
DoCmd.Close acForm, "frmMyMemo"

 

[Petr Danes]

What about using the function InputBox in the Open event of the report?
Seems to me that might do the trick. A report itself is not accessible to
user input the way a form is, but underlying code can run and communicate
with the user.

Petr