Paul Hartland
paul.hartland at googlemail.com
Thu Oct 23 11:51:30 CDT 2014
Oops managed to send with my big clumsy fingers before finished lol Cool, there is another way I used to do things like that as well. I would some times have an additional single field in my query which built the row something like: PrintRow1: iif(checkTS=True, "TScore: " & T_Score & " ", "") & iif(checkZS=True, "ZScore: " & Z_Score, "") Then in the report just have one field for the line called PrintRow1 Paul On 23 October 2014 17:49, Paul Hartland <paul.hartland at googlemail.com> wrote: > Cool, there is another way I used to do things like that as well. I would > some times have an additional single field in my query which built the row > something like: > > PrintRow1: iif(checkTS=True, "TScore: " & T_Score & " ", "") & > iif(checkZS=True, "ZScore: " & S_Score, "") > > On 23 October 2014 17:25, Kostas Konstantinidis <kost36 at otenet.gr> wrote: > >> Rocky and Paul, >> after a little confuse with twiks and centimeters and how to convert each >> to other >> finally it works fine >> >> 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 >> >> -- >> 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 > -- Paul Hartland paul.hartland at googlemail.com