Conditional Formatting

[Claudette Hennessy]

Have been working with Conditional Formatting and have three questions:
(1) I have three conditions; the field of interest contains values of
"Spring" text color set to a green, "Summer", text color set to a pink, or
"Fall" text color set to an orange. I am using Access 2003, which is
supposed to accept three conditions, right? however the form will accept
only two conditions, but will not implement the third. I know the code is
correct, because any of the conditions work if there are only two. Is this
a bug?
(2) Can you conditionally format a cbo box so that certain records have
different background colors?
(3) My forms use the default 16777215 gray. The gray in the choice box is
darker than this. Any way I can grab the default gray for a background
color?
Thank you in advance,
Claudette

 

[Linq Adams via AccessMonster.com]

(1) Using Access 2003 SP2 I have no problem setting text to three different
colors using Conditional Formatting! What color does your third choice
display?

(3) 16777215 is not gray, but rather white, which is the normal back color of
text boxes.The back color for your form sections (Header, Detail, Footer)
which each have to be set if you have all three, is by default set at -
2147483633. This is not an actual color, per se, but represents whatever
color you have set in your Windows preferences for form backrounds. In other
words, if the color is set to -2147483633, and you have the window back color
set to blue in your Windows control panel, your Access forms back color will
be blue. If you change the color to pink in your Windows control panel, your
Access forms will then be pink!

As for changing back colors, you can do this in the Properties box for any
control that allows the back color to be set (notable exceptions are button
colors, dropdown arrows and slider/scroll bars) by entering the number
representing the color you want or by entering one of the Windows control
numbers, such as the aforementioned -2147483633.