Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Events

On the Events tab page you can link macros to events that occur in a form's control fields.

When the event occurs, the linked macro will be called. To assign a macro to an event, press the ... button. The Assign Action dialogue box opens.

To access this command...

Open context menu of a selected form element - choose Control Properties - Events tab.

Open Form Design toolbar, click Control Properties icon - Events tab.

Depending on the control, different events are available. Only the available events for the selected control and context are listed on the Events tab page.
The following events are defined:

Approve action

This event takes place before an action is triggered by clicking the control. For example, clicking a "Submit" button initiates a send action; however, the actual "send" process is started only when the When initiating event occurs. The Approve action event allows you to kill the process. If the linked method sends back FALSE, When initiating will not be executed.

Execute action

The Execute action event occurs when an action is started. For example, if you have a "Submit" button in your form, the send process represents the action to be initiated.

Changed

The Changed event takes place when the control loses the focus and the content of the control has changed since it lost the focus.

Text modified

The Text modified event takes place if you enter or modify a text in an input field.

Item status changed

The Item status changed event takes place if the status of the control field has changed, for example, from checked to unchecked.

When receiving focus

The When receiving focus event takes place if a control field receives the focus.

When losing focus

The When losing focus event takes place if a control field loses the focus.

Key pressed

The Key pressed event occurs when the user presses any key while the control has the focus. This event may be linked to a macro for checking entries.

Key released

The Key released event occurs when the user releases any key while the control has the focus.

Mouse inside

The Mouse inside event takes place if the mouse is inside the control field.

Mouse moved while key pressed

The Mouse moved while key pressed event takes place when the mouse is dragged while a key is pressed. An example is when, during drag-and-drop, an additional key determines the mode (move or copy).

Mouse moved

The Mouse moved event occurs if the mouse moves over the control.

Mouse button pressed

The Mouse button pressed event occurs if the mouse button is pressed while the mouse pointer is on the control.

Note that this event is also used for notifying requests for a pop-up context menu on the control.

Mouse button released

The Mouse button released event occurs if the mouse button is released while the mouse pointer is on the control.

Mouse outside

The Mouse outside event takes place when the mouse is outside the control field.

Before update

The Before update event occurs before the control content changed by the user is written into the data source. The linked macro can, for example, prevent this action by returning FALSE.

After update

The After update event occurs after the control content changed by the user has been written into the data source.

Prior to reset

The Prior to reset event occurs before a form is reset. Returning True approves the reset, returning False cancels the operation.

A form is reset if one of the following conditions is met:

  1. The user presses an (HTML) button that is defined as a reset button.

  2. A new and empty record is created in a form that is linked to a data source. For example, in the last record, the Next Record button may be pressed.

After resetting

The After resetting event occurs after a form has been reset.