page break (1 Viewer)

[steve111]

hi,

is it possible to force a page break after 15 line items

thanks
steve

 

[Meltdown]

Yes, assuming you already have your line numbers control set up.

Add the Page Break underneath your line item controls -- then in the OnFormat event of the section holding your controls and pagebreak, add the following.

If Me.txtLineNums.Value = 15 Then
Me.PageBreak.Visible = True
Else
Me.PageBreak.Visible = False
End If

 

[steve111]

thank you

that is great

can it also be done by counting the number of lines as some of my reports don't have LINE number

what I do have is a field called productno
each productno is a separate line
steve

 

[Meltdown]

The easiest solution is to add the line numbers control to your reports then make txtLineNums invisible under properties -- the event code will still work.

Regards
Melt