conditional format color

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Thank you for responding. I will try setting the color programatically.

Mary
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting of detail section in an access form 2
Conditional Formatting 1
tab control color 1
Not printing conditional formatting 6
Excel Macro to automatically go to the right of the last colored cell 0
Excel 2007 Custom Formatting using [ColorXX] 4
DateDiff Conditional Formating 2
Pick a color from the default palette 2

Back
Top