checking number of pages in report

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

How could I check from VB a number of pages in a report to
alert a user before printing if there are many pages?

Thanks
 
You should check the help files before making a post to a
news group.
This is directly from teh visual basic help files for
access.
Dim intTotalPages As Integer
Dim strMsg As String

intTotalPages = Me.Pages
strMsg = "This report contains " & intTotalPages & "
pages."
MsgBox strMsg
 
Back
Top