Hidden boxes.

[travismp]

I want to hide 3 boxes in a report then have them show up is a set of conditions are met.

I made my 3 'label' boxes and named them hidden1, hidden2, hidden3. I set them all to vissible 'no'

Can I make something and say:

if [Color]=Red, then Show [Hidden1]
if [Color]=Blue, then Show [Hidden2]
if [Color]=Yellow, then Show [Hidden3]

Thanks.

 

[pbaldy]

Sure; I'd first suggest Conditional Formatting (you can't set visible, but you can set font color to get the same effect). To do it in code, you want to do it in the format event of the section containing the controls (presumably the Detail section).

 

[travismp]

are there any samples out there that I can how it works?

 

[pbaldy]

I've been pretty busy, having just come back from a trip. Did you get this sorted out? If not, what are you having trouble with?

 

[travismp]

Paul,

Thank you I did figure something out. Took me a while, but I do have it resolved. thank you for the follow up thou.

 

[travismp]

Also I hope you had a great trip.

 

[pbaldy]

Had a good trip, thanks. Part vacation-part visit to Microsoft. It really does always rain in Seattle!