Paul Hartland
paul.hartland at googlemail.com
Thu Oct 23 11:49:29 CDT 2014
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