(Contents)(Previous)(Next)

Value(sField As String)

Description: Gets the value of the field/column whose name matches the passed in sField string.
Syntax: object.Value(sField)
Parameters:
object Required, the item
sField The field/column name
Remarks: The Value() method can be used to retrieve the value of any field/column of an item. If the field/column value is accessible as a property of the item then it is more efficient to directly access the property value as opposed to calling this method. E.g. appt.Name is more efficient than appt.Value("Name"). Value() should be used when a property call is not available for the required field. The Value() method can also retrieve the value of custom fields.
Returns: A variant containing the data held in the items matching field/column.
Example:
Example:

Set appts = user.Appointments

Set appt = appts.Add

appt.Name = "Write report"

appt.Update

MsgBox appt.Value("Name")


Next