ADO » Field » Value
- Syntax:
- variant = fieldobject.Value
fieldobject.Value = variant
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.
Examples
Code:
objRecord(strFieldName).Value
'Or
objRecord(strFieldName)
'Or
objRecord.Fields(strFieldName)Explanation:
Since this is the default property, all these lines produce the same result.
Code:
For Each objField In rsData.Fields
Response.Write objField.OriginalValue & VBCRLF
Response.Write objField.UnderlyingValue & VBCRLF
Response.Write objField.Value & VBCRLF
Next
Explanation:
You can also search a Fields Collection
See Also:
