Setting height of detail section in VBA

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dixie
    #1

    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


    Tags: None
    • Randy Harris
      #2
      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.Heigh t = 400 will set the detail height to 400 twips, providing
      that there isn't a control that forces it larger.


        Comment

        • Lyle Fairfield
          #3
          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(Can cel As Integer)
          Me.Detail.Heigh t = 1000
          End Sub


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

            Comment

            Previous template Next
            Working...