Field Function

The Field function returns a field object that can be used to return field-specific information.

Field (Control Name) or Field (row index, column index)

Parameters

ControlName - the name of a control on the form (string).

row index, column index - the row and column co-ordinates of the specified field (integer).

Use

The field function was introduced with the field picker tool to ensure that expressions and macros containing form controls were clear.

The Field Picker () is a custom property editor in Designer that allows you to use your mouse to select a control on the form and return the control's default property to the specified property as a field expression.

BE AWARE THAT:

Only host-generated controls have a row and column co-ordinate, therefore if you are wishing to return an inserted control, you will need to name it first and use this with the field function.

Return Value

A control object.

Examples

Function	Returns
Field("CustomerCity")	Returns the value of the default property of the CustomerCity control.
Field(5,20)	Returns the value of the default property of the control found at row 5 and column 20 in identify.

Relates to

Please note that these functions are specifically for use in Designer. The Field function is not supported in the script editor.