Conditional Formatting Part Duex !

[Naz]

Hi

I have a form with a background colour, that i chose from the colour wheel,
i.e. not from the standard fill pallete.
I have several fields where i want the color to change to Green or Blue
based on another field, but when i use conditional formating, the background
colour is limited to the pallette. So if i don't choose any colour the
background appears white, is there a way of having CF only affect the text
colour.

All help is appreciated.


_______________________
Naz,
London

 

[Linq Adams via AccessMonster.com]

If I understand your question correctly, I think setting the Back Style to
Transparent will give you what you want. When the Condition is met, the back
color of the textbox will still be the color of the form, regardless of the
back color showing in the Conditional Formatting dialog box.