| 打印再添一例,自動(dòng)分頁(yè) |
| 問(wèn)題: 方法一: Option Compare Database Dim row As Long Dim RowsInPage As Integer Private Sub 主體_Format(Cancel As Integer, FormatCount As Integer) RowsInPage = 7 row = row + 1 If row >= RowsInPage Then Me.PageBreak18.Visible = True row = -1 Else Me.PageBreak18.Visible = False End If End Sub 方法二: 在報表的代碼界面里面寫(xiě)入以下代碼: Option Compare Database Dim row As Long Private Sub 主體_Format(Cancel As Integer, FormatCount As Integer) row = row + 1 If Me.Section(acDetail).ForceNewPage = 1 Then Me.Section(acDetail).ForceNewPage = 0 Else If row Mod 7 = 0 Then Me.Section(acDetail).ForceNewPage = 1 row = 0 End If End If End Sub |
聯(lián)系客服