A result field is a field that shows a calculated value based on a calibration formula. Use this procedure to set the software to display a colored background when the field value exceeds the specified limit, for example, if the As Found field value exceeds the allowed tolerance. For examples of a field color expression, see IF Expression for Field Color.
-
Open the target form page saved as a .psr file in InfoMaker. For details, see Open a Form Page in InfoMaker.
-
In the Report window, right-click the target table column, and then, select Properties.
-
In the Properties window, select the Fonts tab.
-
Beside the Background Color box, select
.
-
On the Background Color dialog, in the Functions pane, select the if(b, t, f) function, in which b stands for a Boolean expression, t for true, and f for false.
-
Substitute the b argument with the name of the table column whose background you want to mark with a distinct color, and also define the condition.
-
Substitute the t, f arguments with the background color parameters as you require.
You can substitute the t, f arguments with the InfoMaker RGB function rgb(0,0,0) and f with 1073741824, which is the standard Windows Background color set for an editable field. In the
RGB function, you can enter any number in the range between 1 and 255, as you require.
-
Close the Background Color dialog.
On the Font tab, the icon beside the Background Color box changes to
.
You can ignore the color setting displayed in the box because an expression overrides the specific property value defined in the Properties window.
-
Save the .psr file.