Field Object

You can use the Field object to access the properties of an entity field.

For example, to display a message box when a user does not have permission to change a value in the Status field, you can use the following code:

Msgbox "You do not have permission to change "_
& "Bug_Fields.Field("BG_STATUS").FieldLabel field."

The Field object has the following properties:

Property	R/W	Type	Description
FieldLabel	R	String	The displayed label of the field.
FieldName	R	String	The logical name of the field.
IsModified	R	Boolean	Specifies whether the value was modified.
IsMultiValue	R	Boolean	Specifies whether the field can contain multiple values from a lookup list.
IsNull	R	Boolean	Specifies whether the field value is absent.
IsReadOnly	R/W	Boolean	Specifies whether the field is read-only.
IsRequired	R/W	Boolean	Specifies whether a field value is required. This enables you to override field customization information. To modify the IsRequired property of a field, the IsVisible property must be `True`. Changes to IsRequired are ignored if the field is not visible. Users must always enter a value for a field that is set as required by the workflow. This applies whether they are modifying an existing record or adding a new record, and even if the field is already empty.
IsVisible	R/W	Boolean	Specifies whether the field is displayed.
List	R/W	List	Sets or retrieves the field list attached to a field of type lookup list.
PageNo	R/W	Integer	Sets or retrieves the page (tab) on which the field is displayed in the New Defect and Defect Details dialog boxes.
Value	R/W	Variant	Sets or retrieves the value of the field.
ViewOrder	R/W	Integer	Sets or retrieves the order in which the fields are displayed in the New Defect and Defect Details dialog boxes. You must set the value for every field in the dialog box.

Send Help Center Feedback