Print out is different from Print Preview for a Multi-Column report

K

Kevin

I've created a multi-column report that prints labels in the first
column of each page. Everything looks fine on the screen when I print
preview. However when I print out the report, the labels do not print
out on the first page but the rest of the pages are fine. Can anyone
out there help me? The VBA code is below.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Dim i As Integer

If (Me.Left = 720 Or Me.Left = 1800) And Me.Page >
Me.NewPage.Caption Then
Me.NextRecord = False
For i = 1 To 24
Me("b" & i).Visible = False
Me("a" & i).Visible = True
Next i
Me.NewPage.Caption = Me.Page
Else
Me.NextRecord = True
For i = 1 To 24
Me("b" & i).Visible = True
Me("a" & i).Visible = False
Next i
End If

End Sub
 
K

Kevin

OK. I found out that if I print straight from design mode then it
prints out OK. So the problem only occurs when I print from Print
Preview.
 

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

Detail_Format works in Print Preview but Not When Printing 0
Label in Multi column report 0
Word macro that can call cells out of Excel for a find and replace 0
Lablels Report won't print 1
3 labels per report page problem 0
3 labels per page - Allen Browne or FredG maybe??? 0
Print objects only on the last page of a report 3
Page Numbers for Report Groups 0

Top