---
title: "UnderlyingValue Property | Microsoft Docs"
ms.prod: sql
ms.prod_service: connectivity
ms.technology: connectivity
ms.custom: ""
ms.date: "01/19/2017"
ms.reviewer: ""
ms.topic: conceptual
apitype: "COM"
f1_keywords: 
  - "Field20::GetUnderlyingValue"
  - "Field20::get_UnderlyingValue"
  - "Field20::UnderlyingValue"
helpviewer_keywords: 
  - "UnderlyingValue property"
ms.assetid: 00a0c8b8-8b63-433f-95b8-020ab05874a0
author: MightyPen
ms.author: genemi
---
# UnderlyingValue Property
Indicates the current value of a [Field](../../../ado/reference/ado-api/field-object.md) object in the database.  
  
## Return Value  
 Returns a **Variant** value that indicates the value of the **Field**.  
  
## Remarks  
 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 [OriginalValue](../../../ado/reference/ado-api/originalvalue-property-ado.md) property, which reflects the value that was originally returned to the [Recordset](../../../ado/reference/ado-api/recordset-object-ado.md).  
  
 This is similar to using the [Resync](../../../ado/reference/ado-api/resync-method.md) 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](../../../ado/reference/ado-api/resync-method.md) method uses to replace the [Value](../../../ado/reference/ado-api/value-property-ado.md) property.  
  
 When you use this property with the **OriginalValue** property, you can resolve conflicts that arise from batch updates.  
  
## Record  
 For [Record](../../../ado/reference/ado-api/record-object-ado.md) objects, this property will be empty for fields added before [Update](../../../ado/reference/ado-api/update-method.md) is called.  
  
## Applies To  
 [Field Object](../../../ado/reference/ado-api/field-object.md)  
  
## See Also  
 [OriginalValue and UnderlyingValue Properties Example (VB)](../../../ado/reference/ado-api/originalvalue-and-underlyingvalue-properties-example-vb.md)   
 [OriginalValue and UnderlyingValue Properties Example (VC++)](../../../ado/reference/ado-api/originalvalue-and-underlyingvalue-properties-example-vc.md)   
 [OriginalValue Property (ADO)](../../../ado/reference/ado-api/originalvalue-property-ado.md)   
 [Resync Method](../../../ado/reference/ado-api/resync-method.md)