conditional format color

[Guest]

I have a form and I want to make controls appear blank for certain text
string values. I'd like to use conditional format to make the text color the
same as the background color of the control. The problem is that my controls
have custom color backgrounds and the conditional format palette contains
only Access default colors.

Is there any way to change the default palette that Access uses? In Excel,
you can change the palette under Tools - Options.

Mary

 

[Stephen Lebans]

AFAIK you cannot change the colors contained in the palette of the CF UI
Dialog. Instead you will need to programmatically set the
FormatConditions object. In this manner you can specify any color value
you desire.
See:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Thank you for responding. I will try setting the color programatically.

Mary