hiding detail section

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a form that on open hides all labels and controls
except a search combo box in the footer section.

After a selection is made the detail section becomes
visible with the related data.

Is there also a way to hide the detail section background?

michael
 
The only 2 commands I can think of off-hand for what you're trying to do
are:

Me.Section(acDetail).Visible = False
and
Me.Section(acDetail).Height = 0

If these don't do what you need, will you provide more of an explanation.
 
Michael said:
I have a form that on open hides all labels and controls
except a search combo box in the footer section.

After a selection is made the detail section becomes
visible with the related data.

Is there also a way to hide the detail section background?


Not sure I understand what you want here, but if you want
the form to shrink up so the detail doesn't appear at all,
try thins kind of thing:

To shrink the form:
Me.InsideHeight = Me.Section(1).Height _
+ Me.Section(2).Height

To expand it so the detail is displayed:
Me.InsideHeight = Me.Section(1).Height _
+ Me.Section(2).Height _
+ Me.Section(0).Height

Don't forget that user's can drag the form's border to
resize it any way they like and this won't do anything if
the form is maximized.
 
Back
Top