Michael Maddison
michael at ddisolutions.com.au
Sun Oct 12 18:00:06 CDT 2008
Hi Paul, This may not help as I don't use the native VB6 grids (yuk!) but what I would normally do Is add a flag to the sql that returns 0 for personnel and 1 for student. Then do conditional formatting on the row. If the grid lets you do cond formatting that is ;-) Time to talk them into upgrading to dotnet I think! Cheers Michael M -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: Friday, 10 October 2008 10:18 PM To: Access List; VisualBasicList Subject: [dba-VB] Visual Basic 6.0 DataGrid Control - Changing Colour OfCertain Rows To all, I have a Visual Basic 6.0 application which I inherited (lucky me), and now they want to change the way that the DataGrid operates. The grid shows all personnel that are available to do a job for us on that day, some of these however are students. What I need to do (if it's possible) is loop through all the rows on a datagrid, get the personnel number, check if that person is a student, then change the colour of that row if they are. I normally use Infragistic UltraGrid, and it's very easy to do that on there. However I don't really want to change the grid if I can help it. Does anyone know if & how this is possible. Thank you in advance for any help.... -- Paul Hartland paul.hartland at googlemail.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com