How do I display text based on form checkbox?

[Slez via AccessMonster.com]

I have a checkbox, chkRetain, that exists on a subform. When users have it
checked, and they run a particular report, rptProposal, I'd like the
following text to be displayed in one of the group footers:

"This proposal is for material supply only and subject to 0% retainage.
Signed Proposal or Purchase Order will be accepted upon award of project."

When chkRetain is not checked, nothing would display on the report.
The report is run via 2 command buton2 (View & Print).

My questions are:
1. Do I place the text in a label or a text box? I was going to set the Can
Grow property to yes and the height to 0, so it would only take up space when
the text is displayed.
2. What code would be required? (I'm assuming some kind of If / Then / Else
statement, but I don't quite know how to arrange it.)
3. Where should the code be placed?

Help is greatly appreciated! Thanks in advance!

 

[RBear3]

I believe you would use a text box and set it to grow and 0 height as you
stated. Just put the following in your text box...

=Iif([chkRetain],"This proposal is for material supply only and subject to
0% retainage. Signed Proposal or Purchase Order will be accepted upon award
of project.", )