Solved

how can i put a diferente colour in a grid line

Posted on 2011-03-06

1 solution

355 Views

Last Modified: 2012-05-11

how can I put different colors in the lines of a visual foxpro grid so as to highlight certain items.
thanks

Comment

Question by:luciliacoelho

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 42

Expert Comment

by:pcelba

ID: 350484182011-03-06

You may use DynamicForeColor and DynamicBackColor of the Column. To highlite each the second line you may use following code:

THIS.setall("Dynamicbackcolor", "IIF(RECNO()%2=0,RGB(255,255,0),RGB(192,192,192))","Column")

in Grid.Init method code.

Author Comment

by:luciliacoelho

ID: 350486122011-03-06

thanks very much, for the topics. What i want is to change the color of the line numer p.e. 100.

LVL 42

Accepted Solution

by:pcelba

pcelba earned 500 total points

ID: 350489152011-03-06

So, I hope you don't need an update but here it is:

THIS.setall("Dynamicbackcolor", "IIF(RECNO() = 100,RGB(255,255,0),RGB(192,192,192))","Column")

You just have to keep the dynamic expression shorter than 255 characters.

LVL 27

Expert Comment

by:CaptainCyril

ID: 350533702011-03-06

You can also use ICASE() instead of IF() for more choices
ICASE(logical1,color1,logical2,color2,...,colorn)

Or you can call a function that returns a color.
CategoryColor(query.category)

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to loop though a listbox with out making the User select all items in the listbox

Article by: john

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…

Microsoft Development

Top 5 Beginner Programming Pitfalls

Article by: MacroShadow

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.

Excel Error Handling Part 3 -- Run and Fix Bugs

Video by: crystal

This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

[Webinar] How Hackers Steal Your Credentials and Why Active Directory Must be Secure to Stop Them

Video by: Experts Exchange

Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…