1. Home
  2. Docs
  3. Virtual Forms Designer
  4. Properties window: Virtual Forms

Properties window: Virtual Forms

Here you can add, delete or change the properties of a selected Virtual Form.

 

Master Table

Select the Table or Sheet that will be used in this Virtual Form.

When you click on the Choose button it will open a new form where you will be able to select the Table or Sheet.

This property is Required and can not be left blank.

 

Virtual Form Name

This property is automatically filled when you save the Virtual Form. It is generated from the prefix “VF” and the first available number. E.g. “VF2”

Once it is generated it can’t be changed.

 

The Virtual Form Name property is used in the code when you want to identify the Virtual Form object.

For example, in your VBA code you want to open (show to the user) this Virtual Form you will use this ‘Virtual Form Name’ to do this.

 


 

 

This code will open the Virtual Form that is having the ‘Virtual Form Name’ property = VF2

 

More on how to work with Virtual Form Control can be found in Virtual Form Control section in this Help document.

 

Form Caption

Set the caption for your Virtual Form. It will be displayed in the Virtual Form Title Bar.

This property is Required and can not be left blank.

 

ID Field Name

Select the field from the fields list generated from the table specified in ‘Master Table’ property that will be used in this Virtual Form as the ‘ID Field’ (Primary key).

 

Every Table or Sheet must have one field (‘ID Field’) that is unique for the whole Table or Sheet. This is not what the users (programmers) in the Excel (VBA) world are used to do as opposite as the programmers or users in the Relational databases are. But for Virtual Form control to be able to identify the row in your table or sheet, every table or sheet needs this ‘ID Field’. This field must be unique. E.g. 1,2,3,4,…..

 

This field can also be hidden from the users and can be automatically generated by the Virtual Form control (see the details in the ‘ID Type’ – “Possible use cases” below).

 

This Field is also mandatory to be present in the Grid Fields and in the Edit Fields. It can be hidden, but it needs to be present. It is used for binding the Grid control and Edit control together.

 

When you click on the Choose button it will open a new form where you will be able to select the Field.

 

This property is Required and can not be left blank.

 

ID Type

This property is bound to ‘ID Field Name’. Decides how the value will be populated in this field (automatically by the database or the Virtual Form control or we want a custom function that will be passed to an event that is fired by the Virtual Form Control).

 

Possible entries:

Value

Description

Possible use cases

A

Automatically add new values to the ID field. If it is an AutoIncrement field type or if you want that the system auto generates the values for this field

  • If we are using a relational database and the field that we specified in the ‘ID Field Name’ is set to AutoIncrement
  • If this field is not an AutoIncrement, the Virtual Form Control will on saving the Edit Control (more precise on adding new record) get the properties for this field (‘ID Field Type’, and if the ‘ID Field Type’ is C (Text) it will also get the ‘ID Field Length’) and from this properties it will generate the value for the ‘ID Field Name’.

 

Example 1:

‘ID Type’ = A

‘ID Field Type’ = N

Result (the value(s) that will be auto generated in the field that we entered in ‘ID Field Name’): 1, 2, 3, 4, ………

 

Example 2:

‘ID Type’ = A

‘ID Field Type’ = C

‘ID Field Length’ = 7

Result (the value(s) that will be auto generated in the field that we entered in ‘ID Field Name’): 0000001, 0000002, 0000003, 0000004, ………

 

Example 3:

‘ID Type’ = A

‘ID Field Type’ = C

‘ID Field Length’ = 10

Result (the value(s) that will be auto generated in the field that we entered in ‘ID Field Name’): 0000000001, 0000000002, 0000000003, 0000000004, ………

F

Create your own function to manually populate this field

  • In this case, a new property gets visible: ‘Generate ID Function Name’

Here we enter the name of the function that we want to be able to identify in the event that will be fired by the Virtual Form Control at the moment we are going to save the record.

 

 

ID Field Type

It specifies the data type of the field entered in the property ‘ID Field Name’ is.

Possible entries:

Value

Description

N

Numeric

C

Text

See the examples of the use in the description of the property ‘ID Type’

 

ID Field Length

Numeric value only.

It specifies the number of characters of the field entered in the property ‘ID Field Name’ is.

See the examples of the use in the description of the property ‘ID Type’

 

Generate ID Function Name

It specifies the name of the function that will be passed to the event that generates the values for the field entered in the property ‘ID Field Name’.

See the examples of the use in the description of the property ‘ID Type’

 

Buttons Group

Specifies what button group will be used on this Virtual Form.

For more detail on how to use Buttons Groups click here.

 

Maximized Window (Y/N)

It specifies if the first form load will be in a maximized state or in the standard state.

Possible entries:

Value

Description

Y

Y – Yes, open this virtual form in maximized window state

N

N – No, open this virtual form in standard window state (not maximized)

Before Form Open Function

Was this article helpful to you? Yes No

How can we help?