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

[Ashu]

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

 

[Karl Henning]

Try using "True" and "False" in place of "Yes" and "No."