Hide the Detail section of Form

[vttech]

I currently use

Me!frmPatientLookupResults.Form.Visible = False

to hide a subform on my form that is in the detail section of my form.


Is there a way to collapse or Hide the Detail section of the main Form??

I notice that their is a property under the Detail section called Visible
with an option for Yes or No.. How would I manipulate that option through
VBA? I am assuming that is the option that I am looking for


Newbie in search of knowledge

 

[vttech]

I tried

Me.Detail.Visible = False

But no luck. I am looking to collapse that section

Newbie in search of knowledge

 

[SuryaF]

Hiding the detail doesn't resize the form.
Try this:

Sub ToggleDetail()
   Me.Detail.Visible = Not Me.Detail.Visible
'resize the form to Detail + Header + Footer, added 500 more twips for the bar
   Me.Move Me.WindowLeft, , , IIf(Me.Detail.Visible, Me.Detail.Height, 0) + Me.Section(1).Height + Me.Section(2).Height + 500
End Sub