Printing problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanya - 16 Jun 2006 17:15 GMT

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?

Signature

Tanya

Reply to this Message

Jason S. - 18 Jun 2006 08:45 GMT

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.

> I created a report (Client Performance Report) that contain basic header for
> each client, basic instructions and a detail section based on a subreport.
[quoted text clipped - 4 lines]
> page in length?
>

Reply to this Message