Can anyone point me in the right direction

I am using SQL sever 2000 with vb6

I have several datagrids in the application.

some of my grids are read only, some may have one or two columns that can be edited.

is it possible to change the background colour of a specific column to another colour (to indicate to the user that they can edit this column directly)


I've trawled through the net, and cant seem to get very far

I keep coming accross references to header styles etc, but I cant find enough information to be able to explain it. ()ie a tutorial)

I use something like this to change how my grids look now

With Me.datagrid
    .Columns(0).Visible = False
    .Columns(1).Visible = False
    .Columns(2).Width = 1 'OutPutID
    .Columns(3).Visible = True
    .Columns(3).Caption = "Output"
    .Columns(3).Locked = True
    .Columns(3).Width = 4800
    .Columns(4).Visible = True
    .Columns(4).Width = 1000
    .Columns(4).Alignment = dbgCenter
    .Columns(4).Caption = "Amount"

End With


i would like to be able to do something like

.columns(4) colour = red

or

.columns(4) font = ariel, bold

etc

I would appreciate any pointers

Cheers

I don't use this control (yet—though from the problems people seem to have with it I fear the day when I'll need to), but what I would do, is, in running-but-breakpointed code, highlight a reference to the datagrid you are working with. Then right-click that highlit region, and select "Add to watchlist" from the context menu.

Then, in the watchwindow, poke around the reference, expanding properties and such, to see if you can find the property or properties that will allow you to accomplish this. (And if you find the answer, post it here... :))