Snaking Columns (v2000)

Topic

New Reply

(Edited by HansV to provide link to MSKB article using [MSKB=…] 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 Microsoft Knowledge Base Article 208491 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!

Reply | Quote

Replies

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

Don

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote