Value Property

The Value property on a Field object indicates the value assigned to a Field or Property object. This property sets or returns a Variant value. The default value depends on the Type property of the Field object.

oldValue = currentfield.Value
currentField.Value = newValue 

Remarks

The Value property is used to set or return data from Field objects or to set or return property settings with Property objects. Whether the Value property is read/write or read-only depends upon numerous factors. For a Field object, this includes whether the Recordset was opened as read-only or read/write.

ADO allows setting and returning long binary data with the Value property.from the database.