Hide a label on a report when printing (1 Viewer)

[Falcon88]

hii to all

on myForm there two buttons , one "A" for printing MyReport , "B" button for export that report "MyReport" to pdf format .

there a label on that report "MyReport" refer to the electronic version of that report "pdf version" like : this is an electronic version that didn't need to stamp .

my quesion : is there a way to hide that label when printing that report by myForm button "A" ?

 

[Gasman]

You could use OpenArgs?

 

[Falcon88]

You could use OpenArgs?

could you help me please ?

 

[The_Doc_Man]

OK, let's start with the fact that in a report, everything depends on a section and there are events related to each section. In the next link, scroll down to this: "Order of events for reports and report sections" then down to "Events for report sections."

Order of events for database objects - Microsoft Support

support.microsoft.com

Here's a tutorial about event sequences:

Report Event Sequences in MS Access Tutorial 13 September 2023 - Learn Report Event Sequences in MS Access Tutorial (8369) | Wisdom Jobs India

Report Event Sequences in MS Access - Report Event Sequences in MS Access courses with reference manuals and examples pdf.

www.wisdomjobs.com

The idea is that you need to tell Access to suppress (or perhaps change) the message in a particular TextBox control which will appear in a particular section. That section might be the report header, might be the page header for a specific page, might be a group header. You will have to decide which one based on where this message is defined. In your specific case, I'm betting "report header."

When you open a report, there is an argument for the DoCmd.OpenReport action called "OpenArgs" - which is just a quoted string you can pass to the report. Depending on which button was used to launch the report, you can put different values into OpenArgs.

Inside the report, any section can look at Me.OpenArgs. At this point, all you need to do is to put code the correct section format event to test what, if anything, was passed in via the OpenArgs call argument and, based on the text, add, change, or remove the message in question before you exit that particular event.

 

[CJ_London]

surely you just need to change the displaywhen property of the label to screen only?

in your buttonA click event something like

mylabel.displaywhen=2 '1=print only, 2=screen only, 0=both

 

[Falcon88]

PLEASE GIVES ME AN EXAMPLE ...

 

[CJ_London]

you have one in post #5 - and please do not use CAPITALS - it is considered RUDE

 

[The_Doc_Man]

PLEASE GIVES ME AN EXAMPLE ...

We are an advice site primarily. We expect our members to take the advice so as to write their own code. We don't know your environment and have no reasonable way of knowing what would fit in with anything you actually have already. Therefore, we tend to explain how things are done. Some of us offer samples, but we do best when our members learn self-sufficiency.

 

[apr pillai]

A quick thought, On the "A" button click Event set a Temporary Variable with some flag value like 1 or 0.

Write the Code on the OnFormat pass of the Report Section, where the Label is, check the Tempvar value and based on the set value hide/undide the Label.

Report Class Module Code Example: https://www.msaccesstips.com/2009/06/hiding-report-lines-conditionally.html