Sytze,
Bill, I do really appreciate your giving up your time to help me with this.
It seems I have a complete block with this routine
Essentially what I'm after is
My grid has 6 columns and 6 rows
The underlying data in the table, Col 3, row 2 is a character field and says
"MY TEAM v BYE"
What I want to do is, if it contains the word BYE, color this cell Grey Not
the row, not the column, just this cell
It's just not working for me.
-----------------------
I didn't test this, but give it a try. It should be okay or close. If it
fails, let me know
Assuming the sp605 table is available and it has a chr field named courtc6
that may contain "bye"
Thisform.grid1.SetAll("dynamicbackcolor", ;
"IIF(ATC('bye', sp605.courtc6) <> 0,RGB(255,255,0), RGB(255,255,255))",
"Column")
I prefer ATC because it's case insensitive
Replace thisform.grid with a reference to your grid
Replace 255,255,0 with the code for grey
255,255,255 is white
Icase isn't useful for this example, but great when you have a lot of color
choices.
Bill
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
