Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Snaking Columns (v2000)

    (Edited by HansV to provide link to MSKB article using <!t>[MSKB=...]<!/t> tag)

    I have a report with snaking columns that shows various results by territory. I am using text boxes from the record source to label each result in the detail. I only want the text box labels to show up in the first column instead of repeating in all the columns. I looked at the <!mskb=208491>Microsoft Knowledge Base Article 208491<!/mskb> but it applies to a different setup than the one I am using.

    I know this sounds confusing but the attached file should clarify things.
    Thanks!
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Snaking Columns (v2000)

    Andrew,

    This might be a quick fix until you find a better answer. If the number of lines increases or decreases then you will need to adjust the code.

    Option Compare Database
    Dim cnt As Long


    Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)

    cnt = cnt + 1
    If cnt = 7 Then
    cnt = 0
    End If

    Select Case cnt
    Case 4, 5, 6
    Me.txtAcctDef.Visible = False
    Case Else
    Me.txtAcctDef.Visible = True
    End Select

    End Sub <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Don
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Snaking Columns (v2000)

    The method from the MSKB article can be adapted to do more or less what you want. I added some code to move the controls in the second and third columns to the left, to make up for the invisibility of the "label" text boxes. See attached version.
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Snaking Columns (v2000)

    Hans,
    That worked perfectly. Thanks for the shove in the right direction and for the attachment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •