PROPERTY: Field::Value

variant = fieldobject.Value
fieldobject.Value = variant
 
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.
 
Since this is the default property, the following code produces the same results:

Code (VBScript):
objRecord(strFieldName).Value
or
objRecord(strFieldName)
or
objRecord.Fields(strFieldName)

You can also search a Fields Collection:

For Each objField In rsData.Fields
   Response.Write objField.OriginalValue & VBCRLF
   Response.Write objField.UnderlyingValue & VBCRLF
   Response.Write objField.Value & VBCRLF
Next

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information