Conditional background colours

[Guest]

Hi
I have a form where I use conditional formatting. I simply want the
background of the boxes to become the same colour as the standard background
of the form. When I go into CF, I only get a few colours to choose from -
none of which match the existing background. Is there a way to choose a
colour other than the ones shown?
Cheers.

 

[Al Campagna]

Andy,
For a continuous form, and conditional formatting, as far as I know (up
to A2003) you're restricted to the basic colors.

But... if your form is a Single Form, you should be able to control the
backcolors of all your controls with VB.
(On some event... if some condition... YourTextControlName.BackColor
= RGB(nnn, nnn, nnn))

I only refer to a Single form, because changing background colors,
without CF, in a continuous form would cause the background color actually
changes the whole column background.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Stephen Lebans]

Programmatically, the FormatConditions object exposes the Color poperties
which you can set to any RGB color. The CF sample on my site demonstrates
how to accomplish this.

--

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