Format a coloumn in a subform?

  • Thread starter Thread starter Arjan
  • Start date Start date
A

Arjan

Hi all,

Does anybody know how to format a single column in a subform?

What I want to do is color the background of some colomns i.e. blue.
However, I cannot use conditional format as it is also concerning a
checkbox..

Does anybody know how I can do this?

Thanks for your help..

Arjan
the Netherlands
 
Arjan,
Create a box object behind the Checkbox, and use Conditional formatting to change it's
color according the Checkbox value.
 
Arjan,
I'll try... let the "O" represent your Checkbox...

|----------------------------|
| |
| O | <---- Empty Text Control
---------------------------- ex. name ChkBkgrd

Create an empty Text Control with a border and backcolor, around your checkbox, and
"Send it to the Back" so the checkbox shows on top.
Now use Conditional Formatting on the ChkBkgrd object according to the value of the
CheckBox (ex. True = Green, False = Red)
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top