Printing problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a report (Client Performance Report) that contain basic header for
each client, basic instructions and a detail section based on a subreport.
Most of the client reports are two pages so I have set them up to print as
duplex. The problem is that sometimes the data in the subreport my exceed the
line limit which wll then cause that client report to be more than two pages
long. Is there a way to identify those reports that may be more than two
page in length?
 
Yes. The basic report format is static according to size/dimensions. If the
detail section fields are arranged. they're set. Therefore, there's a maximum
number of records for two pages, and that number will always be; until you
change the design. To use a VBA macro- if test the recordsource recordcount
property from the Report_Activate event. You can probably use the _Open event
(IDK); check the help files for VBA/MS Access. The difference between the two
events is _Activate happens after the _Open event, and prior to the _Close
event.
 
Back
Top