how to use more than three conditions in conditional formating

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

Guest

I want to find out how to use more than three conditions in conditionally
formating a form.
Can anybody help?
 
Axe,

The only way I can think of is through VBA; you could add a routine that
checks your conditions and alters the .BackColor property depending upon
its output.

Attach this procedure to the control_Change event and there you go.

However, if you have lots of controls that you wish to work with, it may be
better to write a routine that tests all conditions and modifies all of the
controls; then simply place a call to this routine on the Change event of
all controls.

Not very elegant, but to be honest conditional formatting is usually used
to represent traffic lights - either red, green or amber; therefore not
usually needing more than three conditions.

Hope that helps

John Webb
 
You can only have 3 preset Conditions...period. You can though have a
custom function called to enable you to evaluate more than 3 conditions.
What is it exactly you need to accomplish?

--

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