Label in Multi column report

M

Mail Merge Help

HI

Below is my code on the GroupHeader of the report to print the label on the
left of a multi column report. which it works fine. The lable shows on the
group Header. Could you please show me how to create a lable on the Details
area.

Option Compare Database

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If Me.Left < (1.5 * 1440) Then

Me![LBL1].Visible = True
Me![lBL4].Visible = True
Me![Txt1].Visible = False
Me![txt2].Visible = False
Me![Txt3].Visible = False
Me![tXT4].Visible = False
Me.NextRecord = False

Else

Me![LBL1].Visible = False
Me![lBL4].Visible = False
Me![Txt1].Visible = True
Me![txt2].Visible = True
Me![Txt3].Visible = True
Me![tXT4].Visible = True
End If

End Sub

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


If Me.Top > (3.8 * 1440) Then
Me.NextRecord = False
Me.PrintSection = False
End If

End Sub

.. This is the code for my Details section, but it doesn't work. Could you
please see what's wrong with my code.


Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Left < (1.5 * 1440) Then
Me![lBL4].Visible = True
Me![tXT4].Visible = False
Me.NextRecord = False
Else
Me![lBL4].Visible = False
Me![tXT4].Visible = True
End If
End Sub


Many thanks
Hong
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print out is different from Print Preview for a Multi-Column report 1
Detail_Format works in Print Preview but Not When Printing 0
Change report width based on total columns widths 2
First Report always "true" 3
3 labels per report page problem 0
Showing Only Labels in the First Column of a Report 2
3 labels per page - Allen Browne or FredG maybe??? 0
Rotate Label Code 1

Top