additional conditional formatting

[yourdeployedson]

I have a form that needs conditional formatting for more than three separate results. The background colors for the boxes need to be as such.

CQ needs to be Orange
DFAC needs to be red
Day Off needs to be grey
LNE needs to be yellow
R&R needs to be purple
"null" needs to be white

Obviously i have more than three conditional formats that need to be introduced to the program. The problem is that MS Access doesn't allow more than three. Is there some way for me to use vba coding to conditionally format these boxes with all the needed information i have?

 

[PHV]

Have you tried to play with the FormatConditions collection of the TextBox object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yourdeployedson]

I don't know what you mean ???

 

[PHV]

When in VBE (Ctrl+G) feel free to play with the F2 and F1 keys.

 

[AnotherHiggins]

Didn't have time to really get into this, but here's an MSDN article that might be useful to you:
Extending the Functionality of Conditional Formatting in Access.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.