Subform display

[eacollie]

Is there a way to display/hide the information on a subform using a checkbox?

So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays?

Thanks!

 

[pbaldy]

Like this?

http://www.baldyweb.com/ConditionalVisibility.htm

 

[eacollie]

Thanks pbaldy. This makes the control visible/invisible. I want the control to be visible but the data inside the control to not display.

I've tried setting the controlsource of the control to "" and then using dlookup to reset it, but not having any luck.

 

[pbaldy]

How about setting the font color the same as the back color?

 

[eacollie]

Now why didn't I think of that!!!

Thank you so much

 

[pbaldy]

No problem!