ADO Field Object UnderlyingValue Property

A Field object's current value in the database.

UnderlyingValue Property Return Values (ADO Field Object)

Returns a Variant value.

UnderlyingValue Property Remarks (ADO Field Object)

Use the UnderlyingValue property to return the current field value from the database. The field value in the UnderlyingValue property is the value that is visible to your transaction and may be the result of a recent update by another transaction. This may differ from the ADO Field Object OriginalValue Property, which reflects the value that was originally returned to the ADO Recordset Object.

This is similar to using the ADO Recordset Object Resync Method, but the UnderlyingValue property returns only the value for a specific field from the current record. This is the same value that the Resync method uses to replace the ADO Field Object Value Property.

When you use this property with the OriginalValue property, you can resolve conflicts that arise from batch updates.

UnderlyingValue Property Example (ADO Field Object)

See the ADO Field Object OriginalValue Property example.