Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formatting

Status
Not open for further replies.

papakula

Programmer
Aug 21, 2001
33
GB
Hi,
I want to change the border color of a field depending on the data in it. Like I have field with some 50 values in it, I want to have a different border color for first 16 values or 20 values.
Many Thanks in Advance
 
Hello All,
I am also in need of this solution. Please help .
 
I guess it depends on what kind off data you are working with; her is how I have done it
IF {@snitt kø dag} in [0 to 19,99] then crGreen Else
IF {@snitt kø dag} in [20 to 59,99] then crYellow Else
IF {@snitt kø dag} > 60 then crRed

Rune
 
Rune,
Thanks, What I want is to have different colors for different values Ex: Assuming that there are 4 departments
selected by parameter then the records fetechd by first parameter should should be green
second parameter should be red
third parameter should be yellow
so on..
 
If I anderstand you correctely this shoud work; schose "Format Field"-> "Font"-> press the "formula button" and write:
IF {parameter} = "deparment1"
Then crgreen
Else
IF {parameter} = "deparment2"
Then crred
Else etc.

Rune


 
Hi Rune!
Its not like that. Its not sure that first he may select
department 1, or 2.
if he selects depart 1,2,3
department 1 should be green
2 red
3 yellow

even if he select depart 3,2,1
department 3 should be green
2 red
1 yellow

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top