conditional format criteria too long for one condition

  • Thread starter Thread starter Laoballer
  • Start date Start date
L

Laoballer

I'm using conditional formatting in one of my form for tabular
dataset. I'm using expression is

[fieldname] Not In ('something','something else', ----, etc)

my not in clause is too long for one condition, but if I were to do
two separate conditions whatever isn't in the first or second not in
clause will get highlighted. Is there a way I can continue the not in
clause from the first condition to the second?

Thanks,
 
Hi,

Reverse your thinking. Make the Default Format the Not-In format and
do a number of [fieldname] In ... conditions that format the field with what
is the original default format.

Clifford Bass
 
Hi,

     Reverse your thinking.  Make the Default Format the Not-In format and
do a number of [fieldname] In ... conditions that format the field with what
is the original default format.

                      Clifford Bass

Laoballer said:
I'm using conditional formatting in one of my form for tabular
dataset.  I'm using expression is
Click to expand...
[fieldname] Not In ('something','something else', ----, etc)
Click to expand...
my not in clause is too long for one condition, but if I were to do
two separate conditions whatever isn't in the first or second not in
clause will get highlighted.  Is there a way I can continue the not in
clause from the first condition to the second?
Click to expand...
Thanks,
Click to expand...
Click to expand...

that did it, thanks

Thanks
 
Back
Top