Form Controls

From LibreOffice Help
Jump to: navigation, search

The Form Controls toolbar contains tools that you need to create an interactive form. You can use the toolbar to add controls to a form in a text, spreadsheet, presentation, or HTML document, for example a button that runs a macro.

Choose View - Toolbars - Form Controls.

Icon on the Insert toolbar (you may need to enable this initially invisible icon):

Form Controls
Note.png XML Form documents (XForms) use the same controls.

To create a form, open a document and use the Form Controls toolbar to add and define the form controls. If you want, you can also link the form to a database, so that you can use the controls to manipulate a database.

When you create a form in an HTML document, you can use the form to send data over the Internet.

Note.png LibreOffice only exports the form properties that are supported by the HTML version that you export to. To specify the HTML version, choose Tools - Options' - Load/Save - HTML Compatibility'.

To add a control to a document

  1. On the Form Controls toolbar, click the icon of the control that you want to add.
  2. In the document, drag to create the control.
    To create a square control field, hold down the Shift key while you drag.
Tip.png To add a field from the field list of a table or query to a form, drag a cell into the form. In a text document, you can also drag a column header to add a field to a form. To include a label for the field, hold down the Ctrl+Shift key down when you drag a column head.

Modifying a Control

  1. Right-click the control and choose Control. A dialog opens where you can define the properties of the control.
  2. To specify a accelerator key for a control, add a tilde (~) in front of the character in the label for the control.
  3. You can drag and drop controls from one document to another document. You can also copy and paste controls between documents. When you insert a control from another document, LibreOffice analyzes the data source, content type, and content properties of the control so that the control fits the logical structure in the target document. For example, a control that displays contents from an address book continues to display the same contents after you copy the control to a different document. You can view these properties on the Data tab page of the Form properties dialog.


This icon switches the mouse pointer to the select mode, or deactivates this mode. The select mode is used to select the controls of the current form.

Design Mode On/Off

Toggles the Design mode on or off. This function is used to switch quickly between Design and User mode. Activate to edit the form controls, deactivate to use the form controls.

Design Mode on/off

Control Properties

Opens a dialog for editing the properties of a selected control.


Form Properties

In this dialog you can specify, among others, the data source and the events for the whole form.


Check Box

Creates a check box. Check boxes allow you to activate or deactivate a function in a form.

Text Box

Creates a text box. Text boxes are fields in which the user can enter text. In a form, text boxes display data or allow for new data input.

Formatted Field

Creates a formatted field. A formatted field is a text box in which you can define how the inputs and outputs are formatted, and which limiting values apply.

A formatted field has special control properties (choose Format - Control).

Push Button

Creates a push button. This function can be used to execute a command for a defined event, such as a mouse click.

You can apply text and graphics to these buttons.

Option Button

Creates an option button. Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (Name

property). Normally, they are given a group box.

List Box

Creates a list box. A list box lets users select an entry from a list. If the form is linked to a database and the database connection is active, theList Box Wizard will automatically appear after the list box is inserted in the document. This wizard helps you create the list box.

Combo Box

Creates a combo box. A combo box is a single-line list box with a drop-down list from which users choose an option. You can assign the "read-only" property to the combo box so that users cannot enter other entries than those found in the list. If the form is bound to a database and the database connection is active, the Combo Box Wizard will automatically appear after you insert the combo box in the document.

Label Field

Creates a field for displaying text. These labels are only for displaying predefined text. Entries cannot be made in these fields.

More Controls

Opens the More Controls toolbar.

Form Design

Opens the Form Design toolbar.

Wizards On/Off

Turns on and turns off the automatic form controls wizards.

These wizards help you to enter the properties of list boxes, table controls, and other controls.

Context Menu Commands