conditional formating

[Guest]

Hi yawl.
ACCESS 2003.
what I want is when a person views all record in a form (tabular layout) I
am trying to give color coding to each textbox control depending on the value
inside the box.
I tried using conditional formating but it limits to only three conditions.

I wrote a VB code using RGB() but when all the records loads into the form
still the color does not change depending on value...lets say if the value of
a field is pink in one record its suppose to be in pink color.... and if
yellow is value for the secopnd record its suppose to be in yellow
color...and so forth....

I loaded the funcion in form onload function.... but still it really does
not load it with conditions in the code....any suggestions? or how can i
increase conditional formating default from max 3 to more. Or how can I
reference each row in a table so that i could use for each statement in
visual basic and then give conditions.

 

[Steve Schapel]

Triton,

Just to first of all clarify that you understand that the limit of 3
conditions applies to *each control*?

If you really want more than 3 colour options for each control, this
might be your best bet...
http://www.lebans.com/formatbycriteria.htm

 

[Stephen Lebans]

Hi Steve,
that solution was designed specifically for A97. There is no version for
A2K or higher simply because of the existence of CF.

--

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

 

[Steve Schapel]

Thanks, Stephen. I sorta knew that. But if I ever wanted more than 3
criteria options, that's the first thing I would have tried.

 

[Guest]

Steve,
I appreciate your response.
I am aware of conditional formatting rules ...with MAX 3 conditions but ...
I have 5 colors to be coded in for one textbox ....The textbox control gets
its value from the student table
so lets say.
I have 5 student records in my student table. There is a coloumn called
levels.
from beginner to expert which are actuallly color coded. for example pink
being the beginner..yellow as intermediate ....and so forth.
So i have 5 different colors with 5 levels. So actually color tells me their
level.
Initially the student gets the pink level via. Student registration form.

Now I have a query which would basically output all the records using select
statement.
Now when i view all those 5 records it should display me with the correct
color code format according to the value in the ltextbox....which were
decided when student registered using student registration form.

but some how when the form loads it shows me the right value for level
column for each record but the color is not displayed....
if it would be upto 3 coors then i would have used conditional formating
....and the form loads it showing me right value and color but its not the
case beciuse I have 5 colors.