ActiveX

To assign cell types to a bound sheet

1. Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
2. If you want to override the cell types that are assigned automatically, use code in the DataColConfig event to do so. After each column is assigned a cell type, the DataColConfig event occurs. Therefore, in the DataColConfig event,
   1. Return the assigned cell type using the CellType property at run time if you want to see what cell type the control assigned the cells in the column.
   2. Change the assigned cell type by specifying the column with the Col property, setting the Row property to –1, and then setting the CellType property to the desired type.
3. If you want to set the cell types manually, set the DAutoCellTypes property to False, then assign cell types as described in Setting the Cell Type.