Conditional Page Break

G

gbruintjes

I have a complex report with numerous sub-reports and need to know how
to include a conditional page break based on the existence of a sub-
report.

Below is some code I'm trying but it gives me an error. 'Object
doesn't support this property or method'

MResults = Me![SubReport_M].HasData
Me![MpageBreak].Visible = False
If MResults = 0 Then
Me![MpageBreak].Visible = True
End If

The other block I tried is this, but same error.

Me![MpageBreak].Visible = False
If Me.[SubReport_M].[HasData] Then
Me![MpageBreak].Visible = True
End If

In the end I want the page break to only show up if the sub-report has
data and shows up in the final report.
Any help would be appreciated.

Thanks,
Gerrit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Page Break Challenge 1
Mail Merge Directory Conditional Page Break 0
Word macro that can call cells out of Excel for a find and replace 0
Macro to Select text from a point given to a specific word 2
VBA - exporting serial letters to single documents 0
VBA Export to PDF 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Detail_Format works in Print Preview but Not When Printing 0

Top