ActiveX
To display a database field in a specific column
- Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
- At run time, set the Col property to designate the first column to display a specific field.
- At run time, set the DataField property to the field name in the database table.
-
Repeat steps 2 and 3 for each column for which you want to specify a field.
To see the sheet display the bound field, use Visual Basic's Refresh method.