Form Designer: Toolbar

The toolbar of the Designer dialog box provides distinct commands for creating and editing forms. The toolbar icons are grouped according to their function.

Click an icon to add a control to the form, as shown in the following table:

Icon

Description

 
Note:

The controls TEXTBOX, CHECKBOX, COMBOBOX, COLORBOX, PICTUREBOX and PICTURECOMBOBOX refer to a database attribute. For each attribute, you can apply one appropriate control.

If all database attributes have one of these controls, no further control of this type can be created. The message "All Attributes Have A Control! Would You Like To Replace An Existing Control ?" indicates that there are no attributes without a control in the current form. Click Yes to replace the control. In the Select Control To Be Replaced list you can select the attribute.

 

Controls, used to show a text box, referencing a value

Property TextBox

Class name: TEXTBOX

Adds a text box to show the content of the database attribute. Use a text box to show the content of a database attribute. The Message: All Attributes Have A Control ! means: In the current form, there are no attributes remaining without control.

Read-Only SQL TextBox

Class name: SQLLABEL

Adds an SQL Label. Use this to show the result of an SQL query. You can define a select statement to query any information. The result is shown in the form, but cannot be edited. Example: Use SQL label to calculate the total area of all related parcels.

Editable SQL TextBox

Class name: SQLTEXTBOX

Adds an SQLTextBox: Use this to show the result of an SQL query, for example, to show the area which is stored in a different table. The result can be edited and the value is saved (update). Use this type of control only if you query a single attribute.

Class name: FORMULA

Adds a formula to show the result of a calculation using the database attributes. Use this to calculate values. You can use all database attributes and all mathematical expressions (VB .NET code).

 

Controls that open an editable form, showing all properties of a referenced feature or set of features.

Basic Form Launcher

Class name: REFERENCE

Adds a Reference. Use this to show data related to the current record. Reference controls are created for all relations that point to the current table, for example, the relation to the label feature class.

Note:

This control is set by default, according to TB_RELATIONS

FID Form Launcher

Class name: FIDREFERENCE

Adds a FID-Reference to open a form that belongs to a certain FID (dynamic relation, multi-relation). An FID Reference is not linked to a database attribute of the current table. Use FID References to show data with a special FID.

SQL Form Launcher

Class name: COMLEXREFERENCE

Adds a ComplexReference to create references using complex SQL statements, for example to open a form of another table. A Complex Reference is not linked to a database attribute of the current table. Use this to open the form of another table with a filter. You can define this filter with complex SQL statements.

Advanced Form Launcher

Class name: MULTIREFERENCE

Similar to the Reference control, you can use multi-relations.

 

Combo boxes

Basic Combo Box.

Class name: COMBOBOX

Adds a combo box that enables acquisition through a dropdown list. A combo box is always linked to a database attribute. Use this control to select your entry through a combo box from a domain table (*_TBD) or any other related table.

Color Combo Box.

Class name: COLORBOX

Adds a color combo box that can be used to select a color from a list.

Advanced Combo Box.

Class name: MASTERBOX

Adds an advanced combo box (master box). The master box control is similar to an add-on to the combo box control. Use this control to define one or more filters (pre-selections) for a combo box. For example, to enter a street name, you define a filter for the city. In the form, the master box looks like a combo box.

Picture ComboBox

Class name: PICTURECOMBOBOX

Provides picture file names in a list box.

Model Selector

Class name: MODELBOX

Adds a control for acquisition of model driven attributes. See also Data Model: Model Tables.

 

Linkers

Document Linker

Class name: DOCUMENTMANAGER

Opens the document manager and shows whether any documents are available.

Picture Linker

Class name: PICTUREBOX

Displays record-related pictures.

FID Linker

Class name: FIDBUTTON

Adds an FID button that can be used to select a feature in the map and fill an attribute with this value (data acquisition).

 

Programmable controls

Script-Programmable Control

Class name: SCRIPTBUTTON

Inserts a control that is programmed using VB script.

API-Programmable Control

Class name: APICONTROL

Inserts a control that is programmed as a DLL.

 

Static content

Static Text

Class name: LABEL

Adds a label. Use this to write any text, notes, or remarks in the form.

Static Picture Box

Class name: STATICPICTURE

Adds a StaticPicture: Use this to position a picture in the form, for example, a company logo.

Horizontal Line

Class name: LINE

Draws a line. Use this to paint horizontal or vertical lines into the form.

 

Other controls

Coordinates Editor

Class name: GEOMETRY

Adds a Geometry control to show coordinates and to enable edition of coordinates. Use this to show coordinates (Y, X, Z) in the form.

Checkbox

Class name: CHECKBOX

Adds a Yes/No CheckBox. A check box is always linked to a database attribute. Use this control to show the content of a database attribute which can only be 1 or 0, respectively Yes/No, or Open/Closed.

A check box control is assigned to database attributes which are declared as num (1).

Feature Highlighter

Class name: HIGHLIGHTBUTTON

Highlights a feature in the map.