1. multipage report; 2. Print and preview

[Guest]

hi ng,

I have two difficult questions (at least for me):
1. I have a report with several pages of text, but ACCESS 2000 is only accepting 3 pages. Is there a work around?

2. How can I figure out (maybe via VBA) wether a user has printed a report or only used the preview?

thanks in advance

jokobe

 

[Marshall Barton]

I have two difficult questions (at least for me):
1. I have a report with several pages of text, but
ACCESS 2000 is only accepting 3 pages. Is there
a work around?

Maybe, but it would depend on the design of the report and
the structure of the data the report is trying to process.
Post back with more details.

2. How can I figure out (maybe via VBA) wether a
user has printed a report or only used the preview?

The only distinction between opening a report for printing
or previewing is that the Activate event only fires for
preview mode.

That will not tell you if a user previews a report and then
decides to print the report from the preview toolbar.

Another thing to consider is that, because of paper jams,
ink depletion, etc, there is no way to determine if the
report was actually printed so that a person could read it.

 

[Guest]

thanks for the fast answer.

concerning 1.
I'm printing two adresses and included in a very long text, so I need for the layout exactly 3 pages, each one filled.

 

[Marshall Barton]

thanks for the fast answer.

concerning 1.
I'm printing two adresses and included in a very long
text, so I need for the layout exactly 3 pages, each one
filled.

Sorry, but "very long text" is just not enough detail.
Where does the text come from? a table? What kind of
control are you using to display it?