Visual Basic Datagrid 1

[rspangle]

I have created a datagrid in Visual Basic 6. Does anyone know how to change the width of the individual fields in the datagrid without manually changing them at the top of the structure

 

[mmilan]

Yeah - I did this one for work about a year back...

I think the best way for me to explain this is to simply try and write you a quick Subroutine... Try slapping this in a module...

public sub ChangeColWidth(TheGrid as DataGrid, ColNo as Integer, NewWidth as integer)

'Declare a Column object
Dim TheCol as Column

'Now set it to be the column on the grid we are looking for...

Set TheCol = TheGrid.columns(ColNo - 1)

'Now resize the column
TheCol.Width = NewWidth

'And finally deallocate the reference.
set TheCol = Nothing

end sub

That's just a quick stab at the function - you might have to debug it, but it should be close...

Martin

 

[rspangle]

I'm also looking for a way to do the same thing with a defined recordset. Thanks