>
Value Property
Applies To
Field Object, Parameter Object, Property Object.
Description
Sets or returns the value of an object.
Settings and Return Values
The setting or return value is an expression that evaluates to a value appropriate for the data type, as specified by the Type property of an object. The data type is Variant.
Remarks
Generally, the Value property is used to retrieve and alter data in Recordset objects.
The Value property is the default property of the Field, Parameter, and Property objects. Therefore, the following lines of code are equivalent (assuming Field1 is at the first ordinal position).
varX = rstProducts!Field1
varX = rstProducts!Field1.Value
varX = rstProducts(0)
varX = rstProducts(0).Value
varX = rstProducts("Field1").Value
varX = rstProducts("Field1")
F$ = "Field1" : varX = rstProducts(F$).Value
varX = rstProducts(F$)
See Also
Name Property, Updatable Property.