Checkbox "On" to generate text on a report

[Slez via AccessMonster.com]

What is my best approach to accomplishing the following?

In a form, I'd like to enable users to check a checkbox which results in a
string of text ("This proposal is for material supply only....") appearing on
a report. When the box goes unchecked, then the text would not appear. I'm
assuming that I would not need to store anything in a table, and this would
be all event based.

If there are any known/viewable examples, that would be great. Otherwise,
any help is appreciated!

 

[Carl Rapson]

What is my best approach to accomplishing the following?

In a form, I'd like to enable users to check a checkbox which results in a
string of text ("This proposal is for material supply only....") appearing
on
a report. When the box goes unchecked, then the text would not appear.
I'm
assuming that I would not need to store anything in a table, and this
would
be all event based.

If there are any known/viewable examples, that would be great. Otherwise,
any help is appreciated!

My recommendation would be to pass a parameter to the report in the OpenArgs
parameter of the OpenReport call. Something like:

If chkCheckbox = True Then
DoCmd.OpenReport "report name",,,,,"True"
Else
DoCmd.OpenReport "report name",,,,,"False"
End If

Then, in the Format section where you want the text, something like:

Me.txtMyText.Visible = (Me.OpenArgs = "True")

Carl Rapson