Defer Column Property

ADO and SQL Server

ADO and SQL Server

Defer Column Property

The Defer Column property specifies when data in a column is fetched.

Applies To
Command Object Recordset Object
Syntax

object.Properties("Defer Column") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that indicates when data is fetched, as specified in Settings.

Settings
Value Description
True The data in the column is not fetched until an accessor is used on the column.
False The data in the column is fetched when the row containing it is fetched.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_DEFERRED