mattloflin
Question Askin Lad
- Local time
- Today, 05:31
- Joined
- Dec 22, 2007
- Messages
- 31
I have searched this forum and searched and can't find how to do what i'm about to ask. I have tried different things but none of which seem to work.
Heres the Deal:
1. I have a form that displays results based off a search. I can use the conditional formatting but it limits me to 3. Here is what I need:
If column1 on form1 ="In Production" backcolor = yellow
... "Ready to Ship On Rack" backcolor = pink
... "Print Not Available" backcolor = tan
... "Problems in production" backcolor= red
... "Errors in wiring" backcolor = blue
... "Needs test sheet" backcolor = green
so when the results come up i need the "column1" to be scanned and if it equals one of those criteria then it do it.
2. Will that same code work in the code for a report? I have rptCurrent that is going to be identical to that list in the searched criteria
like rptCurrent.column1 = "....." then vbred
if someone could type up a sample of code just like the first 3 criteria i can take it form there. I'm just lost. I have read things about "cases" and elseif and i understand it but i can't apply it.
Thanks in advance!!
Heres the Deal:
1. I have a form that displays results based off a search. I can use the conditional formatting but it limits me to 3. Here is what I need:
If column1 on form1 ="In Production" backcolor = yellow
... "Ready to Ship On Rack" backcolor = pink
... "Print Not Available" backcolor = tan
... "Problems in production" backcolor= red
... "Errors in wiring" backcolor = blue
... "Needs test sheet" backcolor = green
so when the results come up i need the "column1" to be scanned and if it equals one of those criteria then it do it.
2. Will that same code work in the code for a report? I have rptCurrent that is going to be identical to that list in the searched criteria

like rptCurrent.column1 = "....." then vbred
if someone could type up a sample of code just like the first 3 criteria i can take it form there. I'm just lost. I have read things about "cases" and elseif and i understand it but i can't apply it.
Thanks in advance!!