YourMajesty
asked on
DataGrid control
I have a datagrid bound to an adodc (data control) which accesses an Access database. I want to colour every row a light green colour/color if a field in the record contains a certain value. The other records would be left as they are. How do I do this ?
You can do this in an MS Flexigrid which is a much better control but you have to code in DAO rather than use controls.
Or use MS Hierarchical (?) FlexGrid control, which allows ADO connections.
/Ture
/Ture
I don't think you can do it on MS FlexGrid control neither.
You can:
With MSFlexGrid1
.Row = 1
.Col = 1
.CellBackColor = vbBlue
End With
With MSFlexGrid1
.Row = 1
.Col = 1
.CellBackColor = vbBlue
End With
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
GREETINGS!
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
This question was awarded, but never cleared due to the JSP-500 errors of that time. It was "stuck" against userID -1 versus the intended expert whom you awarded. This corrects the problem and the expert will now receive these points; points verified.
Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them. If you are an EE Pro user, you can also choose Power Search to find all your open questions.
This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
I'm sorry. As far as I can see, there is no way to change the color of individual cells or rows in a DataGrid.
Ture Magnusson
Karlstad, Sweden