Inserting formula fields into a form or report

To insert a formula field into a form (or report), you need to be in form design mode (or report view) first, and then follow these steps:

  1. Select Formula Field from the Insert menu.

  2. The mouse pointer turns to a cross. Place this where you want the field to appear and click once on your mouse. The "Insert Field Wizard" dialog is displayed, turned to the formula field page.

  3. In the Formula Field group box you design the formula you want to insert. You can either:

  1. If you want to show the formula rather than its result, click in the Show Formula checkbox to switch it on.

  2. Click on Next to go to the control type page, where you can choose what sort of control to use with the formula (see Control types).

  3. Click on Next to go to the last page, where you can set field specific attributes, such as Hide Zeros, Hide Errors, and Edit Source.(for setting up two-way links).

  4. Click on Finish to close the "Insert Field Wizard" and return to form design mode (or report view).

The formula field will be inserted at the place you chose.

Repeat the process for every formula field you want to insert.