Hide text on print

[judith]

My user clicks to print a report. A pop up box asks them if they want a
certain clause printing. From clicking on a yes or a no button I then open
the report in design view, set the field visible or not and then reopen the
report in print preview.

I am sure there must be a neater way. I could set a field on the pop up form
and access that from some code in the on format event but i am using a modal
pop up form to get the info. Any suggestions please

 

[Marshall Barton]

My user clicks to print a report. A pop up box asks them if they want a
certain clause printing. From clicking on a yes or a no button I then open
the report in design view, set the field visible or not and then reopen the
report in print preview.

I am sure there must be a neater way. I could set a field on the pop up form
and access that from some code in the on format event but i am using a modal
pop up form to get the info.

As long as the form with the button that prints the report
stays open, you can stuff the popup's Yes/No value in a
hidden text box. Then the report can make the phrase's
textbox/label visible in the report's Open event:

Me.textbox.Visible = (Forms!theform.hiddentextbox = True)

If that's the kind of arrangement you have, then I don't
understand why you want to use a popup box. Why not do away
with that complexity and just use a check box on the form
for users to indicate what the report should do? If you do
not have a form with a button to open the report, you should
create one.