ADO Property Object Value Property

Indicates the value assigned to a Property object.

Value Property Return Values (ADO Property Object)

Sets or returns a Variant value. Default value depends on the ADO Property Object Type Property.

Value Property Remarks (ADO Property Object)

Use the Value property to set or return property settings with Property objects.

Value Property Example (ADO Property Object)

This Visual Basic example demonstrates the Value property with Field and Property objects by displaying field and property values for the Employees table.

Public Sub ValueX()

Dim rstEmployees As ADODB.Recordset

Dim fldLoop As ADODB.Field

Dim prpLoop As ADODB.Property

Dim strCnn As String

' Open recordset with data from Employee table.

strCnn = "driver={SQL Server};server=srv;" & _

"uid=sa;pwd=;database=pubs"

Set rstEmployees = New ADODB.Recordset

rstEmployees.Open "employee", strCnn, , , adCmdTable

Debug.Print "Field values in rstEmployees"

' Enumerate the Fields collection of the Employees

' table.

For Each fldLoop In rstEmployees.Fields

` Because Value is the default property of a

` Field object, the use of the actual keyword

` here is optional.

Debug.Print " " & fldLoop.Name & " = " &

fldLoop.Value

Next fldLoop

Debug.Print "Property values in rstEmployees"

' Enumerate the Properties collection of the

' Recordset object.

For Each prpLoop In rstEmployees.Properties

' Because Value is the default property of a

' Property object, the use of the actual keyword

' here is optional.

Debug.Print " " & prpLoop.Name & " = " &

prpLoop.Value

Next prpLoop

rstEmployees.Close

End Sub