Need more than 3 conditions

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

Guest

I am kind of new at this, so I need some help. I have a form which has
several text fields on it. I want to set up the text fields with 6
conditions, so that if the user puts a 0 through 5 in any one of the text
fields, the back color and the font color will be a particular color. Ex: If
they enter a 0 the text field and the text font color is black, a 1 the color
is grey, and so forth. Since there are only 3 conditions using the pull down
menu, how do I set the other 3? Thanks.
 
As you know, conditionnal formatting is limited to 3 conditions. So you have
to move up to coding your conditions and responses.

have a look at
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000011#chgBkgrndColor

using this you can then create if statement to check against your control
values and make the proper changes. In the past, I place this code in the
current event of the form and the afterUpdate event of the controls in
question and it worked great!
 
Paste your code so we can take a look at it and if possible let us know at
which line the error is trigered.

Daniel P
 
Back
Top