'Show this control' if one of the two check boxes are checked is the same as
'Hide this control' when one of the two check boxes are not checked. So set
conditional formatting on the textbox to 'Hide this control' with two
conditions that say:
1. checkbox 1 is equal to FALSE
OR
2. checkbox 2 is equal to FALSE
---
S.Y.M. Wong-A-Ton
"Jono" wrote:
[Quoted Text] > I need to set a text box's conditional formatting so that it is displayed when
> either one of two conditions in a group are selected. Let's say I have 10
> checkbox choices. Two of these choices require a textbox for further info. I
> want the textbox to be hidden when neither of the two are checked. A logical
> OR gate.
>
> In the conditional formatting I only have the choice to 'hide' the control
> under certain circumstances, this causes a problem: If I say hide this
> control
> if one of the other 8 are checked and I need to check one of them and one of
> the check boxes that need the text box the text box won't show up because of
> the negative conditional formatting.
>
> What I need is 'Show this control' if one of the two check boxes are checked.
>
> Any ideas?
>
|