Hide Detail In A Report

[Derrick T. Davidson]

Hi is it possible to hide the detail in a report with out doing it through the design view.

i.e.
ButtonClick no details (button dims)
ButtonClick show details (button normal)

I guess I am just looking for the code behind the hide detail option in design view to make it easy for the user???

[Derrick T. Davidson]

I tried with a check box using this code.

 
Private Sub chkHideDetails_Click()
If chkHideDetails.Value = True Then
Detail.Visible = False
End If
End Sub

I get the following error message?
“Procedure declaration does not match description of eventor procedure having the same name”

[Derrick T. Davidson]

Figured it out changed the caption rather than dim the button, my code for future enquirers:

If btnHide.Caption = "Hide Detail" Then
    Me.Detail.Visible = False
    btnHide.Caption = "Show Detail"
ElseIf btnHide.Caption = "Show Detail" Then
    Me.Detail.Visible = True
    btnHide.Caption = "Hide Detail"
End If