conditional formatting limits

[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

 

[Allen Browne]

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

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

 

[kpk]

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

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.

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

 

[Allen Browne]

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.

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

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

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

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

 

[Marshall Barton]

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?

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.