Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: how to print 4 records per page using an access report

    i want to print 4 records per page on am access report.

    i found the code for 2, and it works fine but when i try it for 4 it returns an error.
    on the code below txtcounter is set to 1.

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

    If [txtcounter] Mod 2 = 0 Then
    Me.Detail.ForceNewPage = 2
    Else
    Me.Detail.ForceNewPage = 0
    End If

    End Sub


    any suggestions?

  2. #2
    Join Date
    May 2009
    Posts
    258
    What are you using to code for 4 records per page?

    You can try the following:
    Code:
    If [txtcounter] Mod 4 = 0 Then
    	Me.Detail.ForceNewPage = 2
    Else
    	Me.Detail.ForceNewPage = 0
    End If
    Regards,

    Ax

Posting Permissions

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