Conditional formatting on a drop down list on a form?

[Novaember]

Hello
I have a form that the user fills out. There are drop downs where for items they select YES, NO, NAA, NA, FYI.

Is there a way to make it so that when they select NO that box on the form displays in red?

All other selections would be the normal white color, but if they select NO it shows in red?

Thanks!
Nova

 

[vbaInet]

Value Is Equal To No

 

[Novaember]

Sorry I'm not getting it. Where do I put this conditional formatting? On the form? on the table for the drop down list?

thanks!

 

[vbaInet]

On the form, select the combo box and look for Conditional Formatting in the menus or ribbon.

 

[missinglinq]

In version 2003, in Design View, you'd select the Combobox, then

Go to Formatting - Conditional Formatting

Select Field Vaue Is from 1st dropdown

Select Equal to from the 2nd dropdown

Enter "No" in the next box

Then click on the big A (fore color icon)

Select Red from the palette

Click on OK.