Common grids.
- MSFlexGrid
- DataGrid
There are many types.
- DBGrid, DataGrid, MSFlexGrid, MSHFlexGrid, and Sheridan Grids (SSDBGrid, etc.).
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.