Change the backcolor of specified records in a continuous form

  • Thread starter Thread starter Rutie
  • Start date Start date
R

Rutie

Hello,
I'm making a skillmatrix-database for the people I'm working with. So
far so good. There is just one problem that can't seem to fix.
I've made a score-form where we can keep track of the diffrent people.
Each person got his own ID but the score can be between 0% and 100%.
There is a textfield which indicates if the result is "OK" or "NOK", if
the score is under 80% the textfield will indicate "NOK" if it's above
80%it's "OK".
This all is made in a continuous form. So we can see all our people on
one screen. This all works perfect.
To have a quick sight of how's "OK" and how's not, I wanted to change
the backcolor of the records that are "OK" in green and for those who
are "NOK" in red. But this seems not so easy.
Can somebody help me with this problem.
 
Check "conditional Formatting"

The formating is accessed via the right mouse button on whatever field
you want to be formatted differently depending on whatever coditions
that you want to define.

Ron
 
Ron2006 said:
Check "conditional Formatting"

The formating is accessed via the right mouse button on whatever field
you want to be formatted differently depending on whatever coditions
that you want to define.

Ron
Click to expand...

Thank You Ron,
Not quiet what I had in mind, but it's a start. What I really want is
that the whole "detail record line " turns in color.
Thanks anyway.

Rutie
 
There are only two ways that you can control the formatting.

1) conditional formatting which works on ALL forms and the continuous
form also. If you want the whole line to change you would have to put
that code in all fields in the line.

2) formatting performed as logic in the form oncurrent (and other
fields) that will work only on single form and multiple form

Here is an address that covers how to do it on the second method:
http://www.lebans.com/alternatecolordetailsection.htm

The difficulty with second method is that all of the fields then become
fixed length and the user CANNOT change the length. (unless you code
some method for them to do it.)

This link gets you to his table of contents. He has a lot of good ideas
and examples.

Ron
 
Back
Top