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

  • Thread starter Thread starter TLC
  • Start date Start date
T

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.
 
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.
 
TLC said:
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.
Click to expand...


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.
 
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.
 
Back
Top