Check Box to show/hide a field

[colstar80]

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

[Andre]

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