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

Kostas Konstantinidis kost36 at otenet.gr
Wed Oct 22 11:03:42 CDT 2014


Rocky and Paul,
will test your suggestions tomorrow morning and will let you know...

thank's a lot
/kostas

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

Well in that case could you not go into the design mode of the report, note
the top and left positions of the T_Score controls, then if you only want
to show the Z_Score in the on format event of the report, make the T_Score
controls invisible and set the top and left values of the Z_Score controls
to the same as the T_Score controls.

Paul

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

> exactly Paul
>
> -----Αρχικό μήνυμα----- From: Paul Hartland
> Sent: Wednesday, October 22, 2014 5:49 PM
>
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] how to control what to print in a report...
>
> Ok so are you saying that on the report you have a horizontal row with the
> fields on like below:
>
> T_Score: [value]          Z_Score: [value]
>
> And if T_Score is not to be printed then Z_Score moves to the left like
> below:
>
> Z_Score: [value]
>
>
> Paul
>
> On 22 October 2014 15:29, Kostas Konstantinidis <kost36 at otenet.gr> wrote:
>
>  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
>>
>>
>
>
> --
> 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
>



-- 
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 



More information about the AccessD mailing list