How do I change the background color of a subform's detail?

[TLC]

I am attempting to dynamically change the background color of a subform from
an event in the form. I don't seem to be able to do so.

 

[Tom van Stiphout]

On Thu, 6 Dec 2007 05:12:01 -0800, TLC <[email protected]>
wrote:

Check out "Conditional Formatting".
-Tom.

 

[TLC]

I looked into that. It doesn't even seen to be an option. That is when I
open the subform in design mode, goto format, conditional formatting is
grayed out. What I'm attempted to do is give a visual clue that changes can
be made. Normally, they can't. But by pressing a button in the form, the
changable fields change color as does the background. I would like to be
able to do the same in the subform, but I'm blocked at every turn.

 

[Marshall Barton]

I looked into that. It doesn't even seen to be an option. That is when I
open the subform in design mode, goto format, conditional formatting is
grayed out. What I'm attempted to do is give a visual clue that changes can
be made. Normally, they can't. But by pressing a button in the form, the
changable fields change color as does the background. I would like to be
able to do the same in the subform, but I'm blocked at every turn.

Add a text box sized to fill the detail section and use
SendToBack to put it behind all the other controls. Might
want to use Transparent on some other controls, too.

 

[Tom van Stiphout]

Select a control. Then the Conditional Formatting option is available.
Granted, it's not the background of the Details sections, but perhaps
close enough.
Marshall's suggestion would essentially extend this to the entire
subform.

-Tom.