[AccessD] Drawing verticle line in the detail section of areport

Dale and Rocky,

Code like this on the Print event of the report section...

Me.Line (xxx, 0)-(xxx, Me.Height)

... where xxx is the distance (in twips) from the left margin.

567 twips / cm.

Regards
Steve


--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Thursday, October 01, 2009 2:03 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Drawing verticle line in the detail section of 
areport

> I'm just getting ready to solve this problem on a report that has 4 'can
> grow' subreports on it.  And I need a vertical line from top to bottom of
> the section.  There are two section events I'm going to try - OnFormat and
> OnPrint.  I'll draw a vertical line where I want it - but only as high as
> the design height of the section, obviously.  And then set the height of
> that line in one of those events.
>
> I think by the time you get to OnPrint the section height is already maxed
> out - but I'm not sure you can set the Height property of a line at that
> tie.  I know you can do it in the OnFormat event, but I'm not sure the
> section height is at its maximum at that time.
>
> So it'll take a little experimenting.  If you find out anything let us 
> know.
> Otherwise I'll post my solution if I find one.
>
> BTW, the height if the section and/or the line has to be expressed in 
> twips.
> 1440 twips = 1 inch.
>
> Regards,
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
> Sent: Wednesday, September 30, 2009 5:40 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Drawing verticle line in the detail section of a report
>
> Good Evening Everyone,
>
> I have several verticle lines in the detail section of an access report.
> However I have an issue when the detail section expands and the lines do
> not.
>
> Does anyone have some code that will adjust the height of the lines based 
> on
> the height of the detail section of the report?
>
> Thanks!~
>
> Dale
>
>
>
> --
> 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