G Guest Sep 7, 2005 #1 I would like the text or text box to be red if the value is 0 or less and be Green if it is 1 or greater. Thanks Keith
I would like the text or text box to be red if the value is 0 or less and be Green if it is 1 or greater. Thanks Keith
A Allen Browne Sep 7, 2005 #2 Open your form/report in design view. Select the control that is to change color. Choose Conditional Formatting on the Format menu.
Open your form/report in design view. Select the control that is to change color. Choose Conditional Formatting on the Format menu.