This documentation is archived and is not being maintained.

Visual Basic Reference

Visual Studio 6.0

DefaultCursorType Property (Data Control)

See Also    Example    Applies To

Controls what type of cursor driver is used on the connection (ODBCDirect only) created by the Data control.


object.DefaultCursorType [ = value ]

The DefaultCursorType property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value An integer constant or value that specifies a type of cursor driver, as described in Settings.


The settings for value are:

Setting Value Description
vbUseDefaultCursor 0 Let the ODBC driver determine which type of cursors to use.
vbUseODBCCursor 1 Use the ODBC cursor library. This option gives better performance for small result sets, but degrades quickly for larger result sets.
vbUseServerSideCursor 2 Use server side cursors. For most large operations this gives better performance, but might cause more network traffic.


Use this property when the DefaultType property of the Data control is set to dbUseODBC. Refer to the DefaultCursorDriver property of the Workspace object for more information.

Data Type