Conditional Formatting Question

[Roger0x1]

Issue: I have a drop down list populating from a sql database. A series of
entries begin with Highway (i.e. Highway PL03, Highway PL04, etc). I have a
second series of entries that begin with Trans (i.e. Trans PL03, etc). If
one of these two series are selected, I would like a second drop down box to
become visible.

On dropdown box2 I am using conditional formatting that says if box1 does
not contain "Highway" hide this control.

If I select any entry in box1 containing Highway the control remains hidden.

What am I missing?
Thanks.

 

[S.Y.M. Wong-A-Ton]

What contains the text "Highway" or "Trans"? The "Value" of the drop-down or
the "Display Name"? If the "Value" of your drop-down is set to an ID or
something that does not contain the text you are looking for, conditional
formatting will not work like you want it to. You need to set the "Value" to
contain the entries you are checking against.