Conditional format for a label based on a Combo Box

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

Guest

Hello:
I have a Y/N combo box on my form. If the answer is "N", then I would like
to show the label next to; otherwise, hide it.
I checked the "Conditional Format". It seems it works only on the combo box
itself.
Any suggestion on this?
Thanks in advance!
 
Vincdc said:
I have a Y/N combo box on my form. If the answer is "N", then I would like
to show the label next to; otherwise, hide it.
I checked the "Conditional Format". It seems it works only on the combo box
itself.
Click to expand...


Use a little code in the combo box's AfterUpdate event
procedure:

Me.labelname.Visible = (Me.combobox = "N")
 
Back
Top