Re: Not Print Last Page of a Report
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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]
.
Relevant Pages
- Re: Cmd button to print report.
... "Al Camp" wrote: ... > I was referring to the VB code behind an Event Procedure. ... > report macro, since I don't see a Refresh available as a command. ... > Private Sub cmdPrintReport_Click ...
(microsoft.public.access.forms) - RE: Combo box parameter report
... open, in which case it opens the form, passing the report's name to it as its ... the report is then opened from a button on the form. ... The code for the report's Open event procedure is: ... Private Sub Report_Open ...
(microsoft.public.access.queries) - Re: Sort
... The code should be in the event procedure associated with the report's Open ... But it does not get implemented when the report ... >>>Hi Lloyd ... >>>> This opens the report with the records selected by the ...
(microsoft.public.access.formscoding) - Re: Horizontal Line
... In Report properties, select the Event tab. ... Select Event Procedure from the drop down list at the right ... Private lngPos As Long ... Then use code in the detail section's Print event: ...
(microsoft.public.access.formscoding) - Re: Conditional Formatting with more then 3 conditions
... the report section that contains the name text ... [Event Procedure] ... query that I'd like to embed as a sub rpt in the rpt header. ... except for the conditional formatting limitation. ...
(microsoft.public.access.reports) |
|
