Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   Conditional formatting greater than 60 entries (https://www.access-programmers.co.uk/forums/showthread.php?t=307616)

archy321 10-28-2019 09:08 AM

Conditional formatting greater than 60 entries
 
Hello,

I was entering all the requirements for my conditional formatting and found that I think that there can only be up to 50 values that can be entered into the pop up box on the report builder. Is there any way to get more values than 50, or to have the multiple factors in one line such as "expression is instr([field], "one" or "two" or "three")>0

something like that?

pbaldy 10-28-2019 09:20 AM

Re: Conditional formatting greater than 60 entries
 
I believe that's a hard limit. You should be able to have:

instr([field], "one")>0 OR instr([field], "two")>0 OR instr([field], "three")>0

archy321 10-28-2019 09:22 AM

Re: Conditional formatting greater than 60 entries
 
This works perfectly and I wont go over my hard limit! Thank you very much!

pbaldy 10-28-2019 09:26 AM

Re: Conditional formatting greater than 60 entries
 
Happy to help!

isladogs 10-28-2019 09:34 AM

Re: Conditional formatting greater than 60 entries
 
The limit used to be 3 CF conditions until a couple of years ago. In fact it still is using VBA.
I'm trying to imagine having anything like 60 conditions as in your app!

Galaxiom 10-28-2019 03:25 PM

Re: Conditional formatting greater than 60 entries
 
Conditional formatting be really slow if it is very complex logic.

Another alternative may be to put all the logic into the query and derive another field which can then be used for assigning the conditional formatting with a very simple condition.


All times are GMT -8. The time now is 05:29 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World