Field

Top  Previous  Next

 

Form fields are contain the elementary information that is displayed in a form.

 


clip0042


 

 

 

Name

optional


Prompt

Prompting text


Prompt Width

Prompting text width


Data Source

Select from a list the field of native table or related tables


Function

If the field content is calculated then we fill in this property as follows:

 

Contains whatever expression it would be shown in the right part of an assingment command in AutoScript. The equal sign is part of it, for example:

 

=crDate or =iif(PERSON!PERSON!HEIGHT > 100, "overweighed", "ok")

 

The PERSON!PERSON!HEIGHT variable denotes <data group name>!<table name>!<field name> of the current form.

 

If its required to use variables from AutoScript code, into the form, we use:

 

=codevar(VARIABLENAME)


Decimals

Decimal points for numbers


Memo Fun

Optional. For forms that not write directly to database table but used mainly as

parameter reading forms.


Editing Form

In case the field is a foreign key field, then this property contains the name of the form that opens in order to edit the foreign record.


Foreign Edit

True or False to edit the foreign key record


Alignment

Alignment of the field text. Let, Right, Center


Printed



Password

True if it is a password field


Required

True if required (the prompting text becomes bold)


Type

Edit, Combo, Date, Check


Before Exit

Form procedure name that executes before the exit from the field


Line

For fields on Data Groups with operating mode Append or Edit is (-1). In operating mode BrowseEdit the property value is 0, 1, 2...depending on the record number that is edited on the field.


Format

Takes values like : %10s, %10.2f as in the C programming language


Edit Mask



Selection List



Selection List Format



Top

Top field position


Left

Left field position


Width

Width of the field


Height

superseded by theme


Color

superseded by theme


Border Color

superseded by theme


Border Width

superseded by theme


Bevel Inner

superseded by theme


Bevel Outer

superseded by theme


Bevel Width

superseded by theme


Font

superseded by theme