By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

Setting height of detail section in VBA

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"dixie" <di****@dogmail.com> wrote in message
news:JC*****************@nnrp1.ozemail.com.au...
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


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

P: n/a
"dixie" <di****@dogmail.com> wrote in
news:JC*****************@nnrp1.ozemail.com.au:
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


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)
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.