Conditional Formatting

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

Guest

Here is my request. I have a form with a drop down menu
of 4 items. I am trying to write a formula (not code) for
the following action:

=IIF[Classification]="Protected B", [Name]= (Colour of
font will be white). I don't seem to be able to make it
work. I am always missing something.

What I really want is that some field would look like
empty if the classification is Protected B.

Can anyone help me on that formula^

Thanks a bunch
 
Hello,

I think you have to use VBA code. For example, add following code behind
the afterupdate
event of the combo box. It changes the backcolor of customerID field on a
form to white if
you select "alfki" from a combo box:


If Me.Combo45 = "alfki" Then
Me.CustomerID.BackColor = 16777215
Else
Me.CustomerID.BackColor = 13434879
End If

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.
 
Back
Top