Field in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box in a form. Is it possible to have the font change to red
in the field if certain criteria applies? For instance, if "nurse" is chosen
from the drop down list I would want the font to be red so it stands out.

Thanks!
 
I have a combo box in a form. Is it possible to have the font change to red
in the field if certain criteria applies? For instance, if "nurse" is chosen
from the drop down list I would want the font to be red so it stands out.

Thanks!
Click to expand...

Use the Control's Conditional Formatting property.

Select the combo box.
Click on Format + Conditional Formatting
Set Condition1 to
Field Value Is
set it to
equa to "Nurse"
Select the Fore Color you wish.
Save the change.

Note: The bound column of the combo box must be the column in which
the text "Nurse" appears.
 
Back
Top