Conditional background colours

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

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.
 
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."
 
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.
 
Back
Top