Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D - 12 May 2006 23:26 GMT

I would like to add conditional formatting to a section, so that when a
certain check box is checked (not blank) the section becomes shaded. It is
not working. What is happening is that the form is just opening with the
section shaded, no matter what you do to the check box. I can get this
conditional formatting to work if I link it to a text box and not a check
box......but I would like to use the check box.

Thank you in advance for your help.

Reply to this Message

S.Y.M. Wong-A-Ton - 13 May 2006 10:39 GMT

The value of a checkbox is either "TRUE" or "FALSE". So when setting up
conditional formatting on the section, instead of using "is not blank" in the
second dropdown list box on the Conditional Format dialog box, use "is equal
to" in the second dropdown list box and select "TRUE" in the third dropdown
list box.
---
S.Y.M. Wong-A-Ton

> I would like to add conditional formatting to a section, so that when a
> certain check box is checked (not blank) the section becomes shaded. It is
[quoted text clipped - 4 lines]
>
> Thank you in advance for your help.

Reply to this Message

D - 13 May 2006 13:58 GMT

Thank you.

> The value of a checkbox is either "TRUE" or "FALSE". So when setting up
> conditional formatting on the section, instead of using "is not blank" in the
[quoted text clipped - 12 lines]
> >
> > Thank you in advance for your help.

Reply to this Message