OriginalValue Property (ADO)

Indicates the value of a Field that existed in the record before any changes were made.

Return Value

Returns a Variant value that represents the value of a field prior to any change.

Remarks

Use the OriginalValue property to return the original field value for a field from the current record.

In immediate update mode (in which the provider writes changes to the underlying data source after you call the Update method), the OriginalValue property returns the field value that existed prior to any changes (that is, since the last Update method call). This is the same value that the CancelUpdate method uses to replace the Value property.

In batch update mode (in which the provider caches multiple changes and writes them to the underlying data source only when you call the UpdateBatch method), the OriginalValue property returns the field value that existed prior to any changes (that is, since the last UpdateBatch method call). This is the same value that the CancelBatch method uses to replace the Value property. When you use this property with the UnderlyingValue property, you can resolve conflicts that arise from batch updates.

Record

For Record objects, the OriginalValue property will be empty for fields added before Update is called.

Applies To

Field Object

See Also

OriginalValue and UnderlyingValue Properties Example (VB)
OriginalValue and UnderlyingValue Properties Example (VC++)
UnderlyingValue Property