Check Box to appear on report, only when checked?

  • Thread starter Thread starter Randy
  • Start date Start date
R

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
 
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.
 
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.
 
Thanks Allen, that works great.
Allen Browne said:
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.

Randy said:
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
Click to expand...
Click to expand...
 
Back
Top