Forms-Field

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

 

 

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