1. Home
  2. Docs
  3. Virtual Forms Designer
  4. Overview of the user interface

Overview of the user interface

The topics in this section provide a brief overview of Virtual Form Designer’s user interface

 1. Title bar

  • Contains information about the name of Virtual Form Designer
  • Version of Virtual Form Designer installed
  • Current opened Virtual Form Designer project file
  • The last character of the title bar can be *. If this character is present this means that changes have been made and not saved to Project properties (number 4 in the screenshot).

2. Menu bar


Menu Name

Menu Item



New Project

Opens new Virtual Form Designer project. It assigns a generic name for the project “VFProject1.vfdp”

If a project was opened before the start of this action and was not saved, it will first ask whether we want to save changes to the previous project

Open Project…

Allows us to open a saved Virtual Form Designer project

Save Project

Saves changes made to the Project properties (number 4 in the screenshot)

Save Project as…

Ask for the new filename and location where to save the project. Saves changes made to the Project properties (number 4 in the screenshot)


Closes the Virtual Form Designer and if in the meanwhile the project properties have changed, asks for saving the changes

Menu Name

Menu Item




Opens a form with the version info about the installed Virtual Form Designer

Goto Virtual Forms webpage

Opens the homepage of the Virtual Forms (https://www.virtual-forms.com)


3. Toolbar

Toolbar Name


New Form

Opens the wizard that helps us to Create new Virtual Form


Opens the properties of the selected item in the TreeView


Refreshes the TreeView

Collapse All

The Collapse All collapses all the TreeNode objects, which includes all the child tree nodes, that are in the TreeView control

Expand All

The Expand All expands all the TreeNode objects, which includes all the child tree nodes, that are in the TreeView control

Check Update

Checks if there is a newer version available on the Virtual-Forms.com webpage, if available, it will download and install the latest version

4. Project properties

Virtual Form Definition File:

The file name of the Virtual Form Definition File that we are using in this Virtual Form Designer Project.

New – Allows us to create a new blank Virtual Definition File in the destination we want.

Select – Allows us to select an existing Virtual Form Definition File from our computer.

More about the Virtual Form Definition File can be found here.

Database Type:

Choose what database type we will use in this Project:

0 – Access Database, 

1 – MSSQL,

2 – MySQL,

3 – Excel Workbook

This is important because the Virtual Form control needs to know this info so that it can properly format the internal SQL syntax.

Connection String:

The connection string to the database that we use in this project.

Build – Allows us to visually create the Connection String (opens a connection builder dialog)

Samples of Connection Strings:

Database Type

Connection string example


Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\myExcelFile.xlsm; Extended Properties=’Excel 12.0 Macro; HDR=YES;’; Persist Security Info=False


Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\myAccessFile.mdb; Persist Security Info=False

Access with Password

Provider=Microsoft.Jet.OLEDB.4.0; User ID=admin; Data Source=C:\myAccessFile.mdb; Persist Security Info=True; Jet OLEDB:Database Password=MyPassword


DRIVER={MySQL ODBC 5.3 Unicode Driver}; Port=3306; SERVER=; DATABASE=test; USER=root; PASSWORD=mypass; OPTION=3;

MSSQL (Microsoft SQL Server)

Driver={SQL Server Native Client 11.0}; Server=tcp:xxxxxxxxx.database.windows.net,1433; Database=test; [email protected]; Pwd=mypass; Encrypt=yes; TrustServerCertificate=no; Connection Timeout=30;

In the Connection string examples provided you need to change this values if they are used:

Data Source=

The path to your database file (if you are using a file database, the extension of the file must be also entered)

User ID=

User id



Database Password=


More about the Connection Strings can be found on this webpage.

5. Virtual Form Designer Treeview

Visual representation of the Virtual Forms and their structure. More about the Treeview can be found here.

When we first open the Virtual Form Designer the TreeView will have one node. This node represents the definition file (VFFile) that is used in the Virtual Form control.

6. Properties window of the selected item in Treeview

Shows the properties of the selected item in Treeview. More about the Properties of the selected item in Treeview can be found here.

Was this article helpful to you? Yes 1 No

How can we help?