Database Access Controls VB6

Controls

• MSFlexGrid
• DataGrid

Editing Cells is not native to these controls. One trick is to use a hidden text box control with a Grid.OCX (VB4) or a MSFlexGrid.OCX (VB5/6) control to make an editable grid control. It would work by having a hidden textbox on the same form as the Grid Control and positioning it over the relevant cell when editing is to occur. Reference: Editable FlexGrid/Grid Control in VB4/5/6

• Don't confuse the FlexGrid control with the DataGrid control—both controls use the same icon but behave differently.

• The difference between the flex grid controls and the DataGrid control is that both versions of the flex grid control only allow you to look into the database, a snapshot and not a dynaset. With the DataGrid control you can look into the data as well as build up the grid and edit the data.