Spread Designer

Notes:

To set data-binding properties, the Spread Designer view must be the active view. You cannot set data-binding properties for a sheet that you open in the Spread Designer (that is, by choosing Open from the File menu).
If you bind columns to data fields using the Spread Designer and then change the record source for the data control, you must refresh the data control (for example, run your project) before resetting data fields with the Spread Designer. Unless the data control is refreshed, the new data fields will not be reflected in the Spread Designer.

Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
If you want to override the cell types that are assigned automatically, use code in the DataColConfig event at run time. 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.
If you want to set the cell types manually,
1. Open the Spread Designer.
2. From the Sheet menu, choose Data Binding.
  The Data Binding dialog box appears:
3. In the Data Binding dialog box, to manually set the cell types,
  1. Clear the Set Cell Type Automatically check box.
  2. Choose the OK button.