Making label invisible/visible based on some criteria in a form

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

Guest

Hello,

I have a form in MS Access -2000 which retrieves data from a table and based
on the values in two columns a lable on that form has to be made visible /
invisible. The form has a combo box which helps in refreshing the data in
that form. So in the datachange property of that combo box I added the code

If Col1 > Col2 Then
label.visible = Yes
Else
label.visible = No
End if

But this does not work , the default property of that label has been set to
visible = No (right click and properties on that label), even by setting
visible = Yes it does not do the intended functionality of making that label
visible.invisible

Let me know what is the issue.

Thanks,

Ashu
 
Back
Top