|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 11th, 2007, 07:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Not Print Last Page of a Report
Depending on a value on form, I want to not the last page of a report. Using an event procedure of the report , is there a way to code so the last page does not print? I use the Report Open event to perform several other procedure based on the value of the form. I just can not figure out how to stop the last page from printing. Thanks for any help, Lamar 
|
|
#2
July 11th, 2007, 08:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Not Print Last Page of a Report
Lamar wrote:
Depending on a value on form, I want to not the last page of a report. Using an event procedure of the report , is there a way to code so the last page does not print? I use the Report Open event to perform several other procedure based on the value of the form. I just can not figure out how to stop the last page from printing. The report will need a text box that refers to the Pages property. Then the Page event can use the line of code: Cancel = (Me.Page = Me.Pages) -- Marsh MVP [MS Access]
|
|
#3
July 12th, 2007, 05:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Not Print Last Page of a Report
Marshall,
I do not understand when you say "The report will need a text box that refers to the Pages property". I have txtbox named "txtPages" on the last page of the report. How do I refer to this txtPages? "Marshall Barton" wrote: Lamar wrote: Depending on a value on form, I want to not the last page of a report. Using an event procedure of the report , is there a way to code so the last page does not print? I use the Report Open event to perform several other procedure based on the value of the form. I just can not figure out how to stop the last page from printing. The report will need a text box that refers to the Pages property. Then the Page event can use the line of code: Cancel = (Me.Page = Me.Pages) -- Marsh MVP [MS Access]
|
|
#4
July 12th, 2007, 07:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Not Print Last Page of a Report
Any text box that references Pages in its expression will
do. A common thing to do is to put the text box in the page footer section and use the expression: =Page & " of " & Pages -- Marsh MVP [MS Access] Lamar wrote: I do not understand when you say "The report will need a text box that refers to the Pages property". I have txtbox named "txtPages" on the last page of the report. How do I refer to this txtPages? "Marshall Barton" wrote: Lamar wrote: Depending on a value on form, I want to not the last page of a report. Using an event procedure of the report , is there a way to code so the last page does not print? I use the Report Open event to perform several other procedure based on the value of the form. I just can not figure out how to stop the last page from printing. The report will need a text box that refers to the Pages property. Then the Page event can use the line of code: Cancel = (Me.Page = Me.Pages)
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
