changing backcolor based on criteria
- Thread starter johnlatona123
- Start date
johnlatona123
Innovator
- Local time
- Today, 12:22
- Joined
- Sep 20, 2011
- Messages
- 85
please check out my attachments, i marked up the "a" image with some description of the layout of my DB.
i indicated which field is the job status field which contains the field values i am using as criteria for the conditional formatting. please refer the job status field on the report to the conditional formatting items in the "c" document
please let me know if you need more info.
i indicated which field is the job status field which contains the field values i am using as criteria for the conditional formatting. please refer the job status field on the report to the conditional formatting items in the "c" document
please let me know if you need more info.
Attachments
Four things:
1. The job status field name that you are using is incorrect. You are using [job status] whereas the field name is [job_status] (with an underscore).
2. The expressions containing Or is incorrect. An example would be:
3. You need to think about the order of precedence of your conditions. Put the least possible cases at the bottom (if you've not already done that).
4. Ensure that the BackStyle property of the textboxe is set to Normal and not Transparent.
1. The job status field name that you are using is incorrect. You are using [job status] whereas the field name is [job_status] (with an underscore).
2. The expressions containing Or is incorrect. An example would be:
Code:
[job_status] = "running" Or [B][COLOR=Red][job_status] =[/COLOR][/B] "setting up" Or [COLOR=Red][B][job_status] = [/B][/COLOR]"1st piece"4. Ensure that the BackStyle property of the textboxe is set to Normal and not Transparent.
johnlatona123
Innovator
- Local time
- Today, 12:22
- Joined
- Sep 20, 2011
- Messages
- 85
you are right again! i needed to reference the field name with each criteria. that did the trick, thank you!
How timely I see this being discussed. I have just been asked if I can add some conditional background coloring based on if one of two YesNo fields are true.
I thought I remembered that Access could not do conditional coloring on Forms, only Reports. However this thread seems to suggest it will work on forms.
Currently my application makes use of a selected record colored bar, Rx from here:
"Highlight Current Record in an Access Continuous Form"
http://www.upsizing.co.uk/Art53_Highlight.aspx
Do you think I could not break that and add "background color = red" if either of the check boxes are red?
I thought I remembered that Access could not do conditional coloring on Forms, only Reports. However this thread seems to suggest it will work on forms.
Currently my application makes use of a selected record colored bar, Rx from here:
"Highlight Current Record in an Access Continuous Form"
http://www.upsizing.co.uk/Art53_Highlight.aspx
Do you think I could not break that and add "background color = red" if either of the check boxes are red?
What version of Access are you using?
I don't see why the site suggests adding an extra unbound textbox at the header of the form. Anyway, yes you can perform conditional formatting based on the two criteria:
I don't see why the site suggests adding an extra unbound textbox at the header of the form. Anyway, yes you can perform conditional formatting based on the two criteria:
Code:
[B]Expression Is[/B]
Val([Field1]) + Val([Field2]) < 0You're welcome!
Access 2007 SP2 at the moment.
All right, I will give it a try in that case. Thanks!
Amazing, it seems to work and not fight with each other. So the green selection bar wins, and the red background exists if the flag field is true and is not the selected record.
Similar threads
