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: |
Set appts = user.Appointments
Set appt = appts.Add
appt.Name = "Write report"
appt.Update
MsgBox appt.Value("Name")