-
Check Box to show/hide a field
I have crew details on a form with 3 fields, CrewMemberCode, CrewMemberName & CrewDescription. They all currently appear on the form but I want the option of displaying the Crew Description using a check box. I want as default the Crew Description not to be visible and to be shown by the checking of a check box.
Thanks Alot,
Colin Bridges
-
Hi Colin,
here is what i would do.
Open the properties windows of "CrewDescription" ans set "visible" to false.
Open the properties windows of the Checkbox and set "Default" to false.
go to tab "Events" and chosse "AfterUpdate" and open the VB editor.
The procedure should look like this(chktest--> your checkbox name,txtTest--> your "CrewDescription" field)
Private Sub chktest_AfterUpdate()
If Me.chkTest = True Then
Me.txtTest.Visible = True
Else
Me.txtTest.Visible = False
End If
End Sub
Regards Andre
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|