Setting height of detail section in VBA

I know I've asked this question in the last week, but no matter how hard I
look, I can't find it. So I'll type it again.

Is it possible to set the height of the detail section of a report using
vba? I want to be able to set the height in a table and have the detail
section adjust to that height, no matter what it is really set to. Is that
feasible, or is it no. If so, what is the syntax for setting the height of
the detail section of a report?

In retrospect, I may have deleted the question before I sent it because it
is unlikely that it can be done!

dixie

re: Setting height of detail section in VBA

"dixie" <dixiec@dogmail.com> wrote in message
news:JCLLb.355$Gf3.14842@nnrp1.ozemail.com.au...[color=blue]
> I know I've asked this question in the last week, but no matter how hard I
> look, I can't find it. So I'll type it again.
>
> Is it possible to set the height of the detail section of a report using
> vba? I want to be able to set the height in a table and have the detail
> section adjust to that height, no matter what it is really set to. Is[/color]
that[color=blue]
> feasible, or is it no. If so, what is the syntax for setting the height[/color]
of[color=blue]
> the detail section of a report?
>
> In retrospect, I may have deleted the question before I sent it because it
> is unlikely that it can be done!
>
> dixie[/color]

Me.Detail.Height = 400 will set the detail height to 400 twips, providing
that there isn't a control that forces it larger.

re: Setting height of detail section in VBA

"dixie" <dixiec@dogmail.com> wrote in
news:JCLLb.355$Gf3.14842@nnrp1.ozemail.com.au:
[color=blue]
> I know I've asked this question in the last week, but no matter how hard
> I look, I can't find it. So I'll type it again.
>
> Is it possible to set the height of the detail section of a report using
> vba? I want to be able to set the height in a table and have the detail
> section adjust to that height, no matter what it is really set to. Is
> that feasible, or is it no. If so, what is the syntax for setting the
> height of the detail section of a report?
>
> In retrospect, I may have deleted the question before I sent it because
> it is unlikely that it can be done!
>
> dixie[/color]

In the report module:

Private Sub Report_Open(Cancel As Integer)
Me.Detail.Height = 1000
End Sub


--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)