Adding differnet information on various pages of a report.

[Guest]

Hi, how do I go about adding "Department copy" on page "1" of report and
"Customer Copy" on page "2".

 

[Joseph Meehan]

Hi, how do I go about adding "Department copy" on page "1" of report
and "Customer Copy" on page "2".

If you want the same data on each page and the only difference is the
text you noted, I suggest two reports. Just copy the one you have then edit
each to show the text you want.

You can write a little code or a macro to cause both copies to print one
after another.

One advantage of this is if the data grows to more than one page, then
each page can have the same text or if you like only the first page.

 

[Guest]

Thank you Joseph,
I insert a page break and duplicate the report. The text was edited in the
query
Field by creating an expression 1 and expression 2 in separate field column.
The new fields was inserted on the separate report page with the new
information.

 

[Mike Labosh]

Hi, how do I go about adding "Department copy" on page "1" of report

If you want the same data on each page and the only difference is the
text you noted, I suggest two reports. Just copy the one you have then
edit each to show the text you want.

It's been a LOOONG time since I worked on Access reports, but isn't there a
cool thing you can do with like a PagePrint or Format event that fires once
for each page? You could have it select case on the page number and change
the text in a Label?

 

[Guest]

Hi Mike, I would like to learn more about applying Visual Basic information
to my Access forms. Can you provide the Visual Basic information for the
event outline?

 

[Dave M]

Try adding an unbound text box to the page header and set its control source
property to:

=IIf([Page] = 1,"Department copy","Customer copy")

 

[Guest]

Dave, Thank you,
Your procedure works perfectly.

Try adding an unbound text box to the page header and set its control source
property to:

=IIf([Page] = 1,"Department copy","Customer copy")