Check box (1 Viewer)

robert693

Registered User.
Local time
Today, 01:39
Joined
Mar 22, 2001
Messages
38
I have a check box called FullTime in a form that one checks if an employee is full time. If an employee is not full time then a label and a text box appear with further information. They only are supposed to appear when the check box is not checked. I used this in the form current event:
Private Sub Form_Current()
If Me!FullTime.Value = Yes Then
Me!Label113.Visable = False
End If

This does not work. Any help would be greatly appreciated!
 

Jack Cowley

Registered User.
Local time
Today, 01:39
Joined
Aug 7, 2000
Messages
2,639
Be sure you have "visible" spelt correctly and then try this....

Private Sub Form_Current()
If Me!FullTime = -1 Then
Me!Label113.Visible = False
Else
Me!Label113.Visible = True
End If
 
R

Rich

Guest
Private Sub Form_Current()
If Me!FullTime.Value = Yes Then
Me!Label113.Visable = False
Else
Me!Label113.Visable = True
End If

FullTime AfterUpdate
Form_Current
 

robert693

Registered User.
Local time
Today, 01:39
Joined
Mar 22, 2001
Messages
38
Thank you for your responses. Jack I used yours and it worked but I was wondering why
-1 is what works and not true?
 

Jack Cowley

Registered User.
Local time
Today, 01:39
Joined
Aug 7, 2000
Messages
2,639
True or Yes will work as well. I am just in the habit of using -1 or 0. Strictly a personal choice....
 

Users who are viewing this thread

Top Bottom