D
dg
Hi, how do I go about adding "Department copy" on page "1" of report and
"Customer Copy" on page "2".
"Customer Copy" on page "2".
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dg
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.
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.
M
Mike Labosh
Hi, how do I go about adding "Department copy" on page "1" of report
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?
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?
D
dg
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?
to my Access forms. Can you provide the Visual Basic information for the
event outline?
D
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")
property to:
=IIf([Page] = 1,"Department copy","Customer copy")
D
dg
Dave, Thank you,
Your procedure works perfectly.
Your procedure works perfectly.
Dave M said:Try adding an unbound text box to the page header and set its control source
property to:
=IIf([Page] = 1,"Department copy","Customer copy")