[AccessD] how to control what to print in a report...

Don't know if this will help but if you want NOT to print a record put your
test in the Format event and if true then:

    Me.MoveLayout = True
    Me.NextRecord = False
    Me.PrintSection = False

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Wednesday, October 22, 2014 7:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] how to control what to print in a report...

Hi Rocky,

This was exactly my first attempt to design the report in which should be
printed in one or the other field on the same horizontal position .
But later when in many cases there was a need to print both of them what
about the blank space that is created when e.g. the first row may be hidden.
The dimensions must be absolutely fix because the report is printed on a
special and pro-designed A4 paper...

So If it could be possible to shrink the blank space for the first invisible
field (label and text box) it would be great.
But I didn't manage to do it.
That's the reason I am looking for another solution.

thank's


-----Αρχικό μήνυμα-----
From: Rocky Smolin
Sent: Wednesday, October 22, 2014 4:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] how to control what to print in a report...

Without knowing exactly how this looks on the form and how you want it to
look on the report, I usually use the Format event of the detail section of
a report to test values and make the text boxes visible or invisible
depending on the rule.

R


On 22 October 2014 12:31, Kostas Konstantinidis <kost36 at otenet.gr> wrote:

> Hi all,
> inside a form there are two fields: T_score and Z_score and two
> checkboxes: checkTS and checkZS
> what I need is to print every time one of the T_score or Z_score or in 
> many cases both of them, depending of a selected checkbox could you 
> please help me?
>
> Thank you in advance
> /kostas
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



--
Paul Hartland
paul.hartland at googlemail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com