Syntax
| variant = fieldobject.Value
fieldobject.Value = variant
|
|---|---|
Description
| Returns a variant that is the current (visible) field value in the current recordset.
The Value property sets or returns a variant that is the current value of the Field object. It may not be the same as the original value, the underlying value, or the value stored in the database.
You can obtain the underlying value using the UnderlyingValue property. You can obtain the original value using the OriginalValue property.
After a new Field object has been added to the Fields Collection, you must first set the Value property and perform an update before you can set any other property.
|
See Also
| OriginalValue, UnderlyingValue, Value, Parameter.Value, Property.Value, Recordset.CancelBatch, Recordset.CancelUpdate, Recordset.Update, Recordset.UpdateBatch.
|
Example
| objRecord(strFieldName).Value
'Or
objRecord(strFieldName)
'Or
objRecord.Fields(strFieldName)
explanation:
Since this is the default property, all these lines produce the same result.
For Each objField In rsData.Fields
Debug.Print objField.OriginalValue
Debug.Print objField.UnderlyingValue
Debug.Print objField.Value
Next
|