DrLechter
asked on
Conditional Formatting - more than 3 conditions
Is there a way to "hack" Access to allow more than 3 conditional formatting conditions on a field? I actally need 7. The purpose of all this is to have one big subform in datasheet mode where each row is colored differently (7 colors) depending on some data condition.l
this is possible using continuous form, not datasheet.
ASKER
Does anyone know where the conditional formatting expressions are stored? Perhaps if they're in a system table, the table could be hacked to add additional (more than 3) conditions.
You can't hack system tables. You can only Read from system tables.
mx
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
shaydie:
I can't find the On Detail Paint event you're referring to. Would you elaborate this?
I can't find the On Detail Paint event you're referring to. Would you elaborate this?
I'm guessing:
Private Sub Detail_Print () ' PRINT
mx
Private Sub Detail_Print () ' PRINT
mx
DrLechter,
Are you using a continuous form as suggested at http:#a32168269
Are you using a continuous form as suggested at http:#a32168269
Detail_Print is for reports..
Detail_paint is for continuous and datasheet forms
Detail_paint is for continuous and datasheet forms
Detail_Print is for reports..
Detail_paint is for continuous and datasheet forms and reports
Detail_paint is for continuous and datasheet forms and reports
yes PAINT
ASKER
Capricorn:
Yes, I am using a continuous form. I just don't see this detail_paint event in any of the event lists. Where is it?
Yes, I am using a continuous form. I just don't see this detail_paint event in any of the event lists. Where is it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hmm. Is that a 2007 thing? I'm using 2003 at the moment.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help everyone. Maybe one day, MS will allow more than 3 conditions. For now, we'll have to suffer
Also ... note that if you end of with 3 conditions and a LOT of records say in a datasheet or continuous form view, CF gets pretty slow ... especially when scrolling.
mx