Need more than 3 conditions

[OEB]

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.

 

[Daniel]

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!

 

[Daniel]

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