By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,335 Members | 2,718 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,335 IT Pros & Developers. It's quick & easy.

DYNAMIC new page forcing

P: n/a
I need to force the new page in a particular point of a report
according the value of a variable or an expression (if varX=true then
force the new page).

Thanks in advance for tips.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Put a page break on your report, and set its visible property according to
whether you want to break or not.

HTH
- Turtle

"Marco" <fa********@tiscali.it> wrote in message
news:21**************************@posting.google.c om...
I need to force the new page in a particular point of a report
according the value of a variable or an expression (if varX=true then
force the new page).

Thanks in advance for tips.

Nov 13 '05 #2

P: n/a
fa********@tiscali.it (Marco) wrote in message news:<21**************************@posting.google. com>...
I need to force the new page in a particular point of a report
according the value of a variable or an expression (if varX=true then
force the new page).

Thanks in advance for tips.


You can use code in the onformat event of the detail section of the report e.g.

If Nz(Me!pagebreak, 0) = -1 Then
Me.Detail.ForceNewPage = 1
Else
Me.Detail.ForceNewPage = 0
End If

where pagebreak in this case is a boolean that is not visible on the report.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.