Recent content by Michelle0531

And, just a note, every other code I've worked on so far has worked. Just the visible one is the problem. Not sure what I'm doing different with that one.

No luck. The box stays visible no matter what. I also have the same problem with another visible code. The field stays visible no matter what. I want it to be invisible if the field is empty. See below: Private Sub Salary_OnCurrent() If Salary = 0 Then Salary.Visible = False...

Sorry...it's this (I always forget that /365): Private Sub Vested_OnCurrent() If (Now() - StartDate)/365 >= 5 Then Vested.Visible = True Else: Vested. Visible = False End If End Sub

I changed my code to read the following and the box still stays visible no matter what: Private Sub Vested_OnCurrent() If Now() - StartDate >= 5 Then Vested.Visible = True Else: Vested.Visible = False End If End Sub

What I'm looking for is to have a box be visible only if the years of service is more than 5. When I say it's not working, I mean the box stays visible no matter what. Do I need to change the Click to OnCurrent?

Help! I'm trying to create a code that will display a field depending on the value of a calculation. Basically, if the years of service is greater than 5, I want the field to show. Otherwise, I do not want it to show. Here's what I have and I cannot get it to work. Can anyone help? Private Sub...