conditional format criteria too long for one condition

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,
 
C

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
 
L

Laoballer

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
[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?

that did it, thanks

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top