Don't print form page 2 if no data

[mulligh]

I have a very long form with a page break in the middle. Is there some code I can put in that will prevent it from printing a second page if there's no data on that page?

 

[JoaoTL]

Hi, above is an idea to work with, you can use this code on the OnFormat() Event.

If Me.Page = 2 then
On Error GoTo HandleErr

HandleErr:
Select Case Err.Number
Case Err = 2501 Then
'WORK TO DO NOT PRINT THIS PAGE
'MAYBE ANYONE JUMP IN AND HELP
End Select
End If

Best Regards

---
JoaoTL
NOSPAM_mail@jtl.co.pt

http://www.jtl.co.pt

http://www.jtl.co.pt/Access

 

[Toga]

I don't know how often page 2 will be blank but why not do this through the normal print process rather than trying to code something. When you select print from the pull down, just specify page 1 of 1. Unfortunately, this option isn't available if you just click the button control instead.