Fixed text, variables, formulae, functions, operators and the like – generally referred to below as "Elements of expressions" – are all inserted and combined by means of a common dialog.
The formula wizard helps you with your entries in several ways:
▪ Function syntax display: A tooltip appears describing the chosen function; it lists the required parameters and shows the result type.
▪ Auto complete: When you type a letter, the available functions, fields and variables are listed that begin with this letter. Within functions, suitable values are suggested for parameters.
▪ Syntax coloring: Functions, parameters, operators and comments are shown in different colors.
▪ Automatic type conversion: Variable and field types are converted automatically when inserted in existing expressions to ensure that the data type corresponds to that expected.
Figure 10.3: Autocomplete in the formula wizard