SelectionMode = cellSelectionByRow only the selected row can also select the whole table, the column can not be selected, but not free to choose SelectionMode = cellSelectionFree freely chosen, can be selected rows and columns and cellSelectionByRow SelectionMode = cellSelectionByColumn contrast, only the column select only select SelectionMode = cellSelectionNone A cell
Tomorrow, you have to set the SelectionMode property of Grid1 in the query to cellselectionByrow. This is also the same as the basic data form. It is also the same SelectionMode property set to cellselectionByrow haha. Complete Private Sub Grid1_Click () 'to prevent multiple choice. Choose a line of Grid1.Range (grid1.activecell.row, 0, grid1.activecell.row, 0) .Selectedendend Sub
ENSUREVISIBLE method
This method can scroll through the Flexcell control to ensure that the cell is visible.
Autofit method
This method is used to automatically adjust the column width of the specified column in the table, so that the cells can accommodate all cell text without folding.
