Conditional format for a label based on a Combo Box

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!
 
M

Marshall Barton

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.


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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top