Have Geek Brain

Disable column in MSHFlexGrid in VB6.0

How can I disable certain columns MSHFlexgrid

in VB6.0? I don't want my user to edit the values ​​in a specific column.

0


a source to share


2 answers


I don't think the MSHFlexGrid control allows users to edit their data in the first place. So essentially all columns are disabled. The task:)

In fact, you have to add special code to enable the update, eg. add an appropriate control (textbox, combo, date picker, etc.) that allows you to edit, hide it at design time, and then at runtime detect which grid cell should have focus, move and resize the control, to make it fit the cell, then handle events to validate the input, then write the content back to the recordset ...



... or you can purchase a third party control that does it all out of the box. The MSHFlexGrid that ships with VB6 is essentially a scaled down version of VSFlexGrid Prowhich I used and thought was pretty good. It has a different way of processing hierarchical data by creating groups (not ranges) that are superior to IMO. The best thing to say about MSHFlexGrid is that it's easy to bind to a hierarchical ADO Recordset to just display the results, but not great if you want to do nice formatting or make the grid editable. VSFlexGrid Pro, if you can afford it, has more power, for example. you can create datasource classes to handle binding to custom data structures (ships with VB6 examples including ADO record binding), which would be invaluable IMO if you intend to make your hierarchical grid editable.

+3


a source


'The bright path here ... is NOT right. But you can try

'if you need to lock the first 3 columns please use this code:



msf2=name of MSFlexGrid
Private Sub msF2_EnterCell()
With msF2
    If msF2.Col = 0 Or msF2.Col = 1 Or msF2.Col = 2 Then
        msF2.Col = 3
    End If
End With
End Sub
0


a source






More articles:


All Articles