conditional formatting limits

  • Thread starter Thread starter kpk
  • Start date Start date
K

kpk

I have a product field on a report that I need to alter the text color and
italicise it if it meets eight (or possibly more) conditions. The
conditional formatting wizard only allows for three conditions so how do I
overcome this?

Regards
Kieran
Using access 2000
 
You can combine multiple conditions into one Expression, e.g.:

(([MyField] < 0) OR ([MyField] > 100) OR ([MyField] Is Null)) AND
([SomeOtherField] = "Okay")
 
Thanks Allen thats useful to know, but how do I apply it? I cant combine
multiple conditions in the conditional formatting wizzard

Allen Browne said:
You can combine multiple conditions into one Expression, e.g.:

(([MyField] < 0) OR ([MyField] > 100) OR ([MyField] Is Null)) AND
([SomeOtherField] = "Okay")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kpk said:
I have a product field on a report that I need to alter the text color and
italicise it if it meets eight (or possibly more) conditions. The
conditional formatting wizard only allows for three conditions so how do I
overcome this?

Regards
Kieran
Using access 2000
Click to expand...
Click to expand...
 
You can use a complex expression in the Conditional Formatting wiz:

1. Open your form in design view.

2. Select the box the formatting should apply to.

3. Choose Conditional formatting from the Format menu.

4. Under 1, choose:
Expression Is
and type in the expression in the wide box beside that.


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

kpk said:
Thanks Allen thats useful to know, but how do I apply it? I cant combine
multiple conditions in the conditional formatting wizzard

Allen Browne said:
You can combine multiple conditions into one Expression, e.g.:

(([MyField] < 0) OR ([MyField] > 100) OR ([MyField] Is Null)) AND
([SomeOtherField] = "Okay")


kpk said:
I have a product field on a report that I need to alter the text color and
italicise it if it meets eight (or possibly more) conditions. The
conditional formatting wizard only allows for three conditions so how
Click to expand...
Click to expand...
do
I
Click to expand...
Click to expand...
 
kpk said:
I have a product field on a report that I need to alter the text color and
italicise it if it meets eight (or possibly more) conditions. The
conditional formatting wizard only allows for three conditions so how do I
overcome this?
Click to expand...


Let's be clear here, the number of different property
setting combinations (such as italics + Red) is limited to 3
(plus the default).

The number of conditions that can be tested to select one of
those three property combinations can be nearly unlimited.
As others have mentioned, you can use a complex expression
to test many conditions or you can write a user defined
function that checks lots of things and returns a True or
False.
 
Back
Top