Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-28-2019, 09:08 AM   #1
archy321
Newly Registered User
 
Join Date: Sep 2018
Posts: 11
Thanks: 4
Thanked 0 Times in 0 Posts
archy321 is on a distinguished road
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?

archy321 is offline   Reply With Quote
Old 10-28-2019, 09:20 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,377
Thanks: 13
Thanked 4,121 Times in 4,053 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
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
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
archy321 (10-28-2019)
Old 10-28-2019, 09:22 AM   #3
archy321
Newly Registered User
 
Join Date: Sep 2018
Posts: 11
Thanks: 4
Thanked 0 Times in 0 Posts
archy321 is on a distinguished road
Re: Conditional formatting greater than 60 entries

This works perfectly and I wont go over my hard limit! Thank you very much!

archy321 is offline   Reply With Quote
Old 10-28-2019, 09:26 AM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,377
Thanks: 13
Thanked 4,121 Times in 4,053 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Conditional formatting greater than 60 entries

Happy to help!
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 10-28-2019, 09:34 AM   #5
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,284
Thanks: 115
Thanked 3,088 Times in 2,806 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
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!
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-28-2019, 03:25 PM   #6
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,710
Thanks: 105
Thanked 1,511 Times in 1,424 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
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.

Galaxiom is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Default formatting option in Conditional formatting Dialog? prabha_friend Forms 11 08-04-2014 05:18 AM
Help with Conditional Formatting helen85 Reports 2 07-14-2010 08:08 AM
Conditional formatting - Blank entries Jennacat Forms 5 04-04-2008 07:07 AM
Conditional Formatting to Identify Same Value Entries sclark Reports 2 03-09-2007 11:45 AM
Count tabel entries that contain greater that 0 amount in particular field Bguyer Reports 1 02-28-2002 03:47 PM




All times are GMT -8. The time now is 10:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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