You can format objects, such as database fields, based on some logic by following the below steps:
1. Right-click on the object in the workspace and select Format Field.
2. Select the Font tab.
3. Perform the necessary formatting. For example, to change the color of the text, select the formula button next to the Color option. In the Formula Workshop, write the log which will determine whether the field will be a specific color. The result of the statement must be a Crystal Color, such as crRed. A sample of changing the color of a field to Red if the related account's state is ACT, enter the following formula:
if {EV870_ACCT_MASTER.EV870_COUNTRY} <> "AUS" then
crRed
Entering a formula always overrides the checkbox setting. The formula button will display in red as an indicator that the checkbox setting will be overridden.
Comments
0 comments
Please sign in to leave a comment.