Check Box to appear on report, only when checked?

[Randy]

I have a checkbox on my form named [Retest]. I also have this on my report.
What I would like is have the check box label "RETEST" appear on my report,
but only when it is checked on my form. It would be invisible if box is not
checked. Is this possible...Thanks...Randy

 

[Duane Hookom]

You might be able to use Conditional Formatting. I would add code to the On
Format event of the section containing the check box:

Me.chkRetest.Visible =(Me.chkRetest=True)
If the label is "attached" to the check box, it should dissappear with the
check box.

 

[Allen Browne]

Change the label into a text box, and give it this Control Source:
=IIf([Retest], "RETEST", Null)

To have the box show only when visible, delete it and replace it with a text
box also. Give the Text box these properties:
Control Source Retest
Font Name Wingdings
Format: ;\ü

The Format is actually these 3 characters:
- semicolon;
- backslash;
- hold down Alt, and type 0252 on the numeric keypad.

 

[Randy]

Thanks Allen, that works great.

Change the label into a text box, and give it this Control Source:
=IIf([Retest], "RETEST", Null)

To have the box show only when visible, delete it and replace it with a text
box also. Give the Text box these properties:
Control Source Retest
Font Name Wingdings
Format: ;\ü

The Format is actually these 3 characters:
- semicolon;
- backslash;
- hold down Alt, and type 0252 on the numeric keypad.


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a checkbox on my form named [Retest]. I also have this on my report.
What I would like is have the check box label "RETEST" appear on my report,
but only when it is checked on my form. It would be invisible if box is not
checked. Is this possible...Thanks...Randy