[AccessD] Vertical line in detail section

Rocky Smolin rockysmolin at bchacc.com
Sun Jun 19 09:44:42 CDT 2016


Actually, that might work if I move the details out of the subreport and
into the main report.

Thx.

r
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Saturday, June 18, 2016 10:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Vertical line in detail section

An ugly kludge, but it works:

http://www.access-programmers.co.uk/forums/showthread.php?t=194657


On 18 Jun 2016 at 7:55, Rocky Smolin wrote:

> Dang.  Forgot about Line.  But I didn't know it would truncate the 
> line to the height of the detail section. Mil gracias for that!
> 
> Now the last thing (OK it's never last, but...) I need to draw a 
> horizontal line across the page below the last detail line on the 
> page.  Originally I had a line separating each detail line and that 
> looked OK to me.  But not to him.
> 
> I could make that line invisible and make it visible only when 
> printing the last detail line on the page.  But how to know when the 
> line being printed is the last one on the page?
> 
> Or is there some other method that you know of to get that line across 
> the bottom of the last detail line on the page.
> 
> MMTIA
> 
> r
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Stuart McLachlan Sent: Saturday, June 18, 2016 6:31 AM To: Access 
> Developers discussion and problem solving Subject: Re: [AccessD] 
> Vertical line in detail section
> 
> Don't use a Line control.  Use  Me.Line (X, 0)-(X, Y)  in the 
> Detail_Print
> 
> Set Y to 22 inches or the equivalent number in cms, twips, pixels 
> depending on how you Scale your report.  (i.e. maximum possible size).
>  The detail will NOT be expanded to the full line length - the line 
> will be truncated to the length of the detail.
> 
> --
> Stuart
> 
> 
> 
> 
> On 18 Jun 2016 at 5:40, Rocky Smolin wrote:
> 
> > Dear List:
> > 
> > I have a client who wants vertical lines in the detail section 
> > between data fields.  This is no problem when the detail section is 
> > a fixed height. I've done lots of those before - just make the 
> > vertical line the exact height of the detail section and you get a 
> > nice continuous vertical line wherever you want it on the report.
> > 
> > Problem in this case is that there are "Can Grow" fields in the 
> > detail section which makes the detail height different for each 
> > detail line.
> > 
> > I put a MsgBox Me.Detail.Height in the Format, Retreat and Print 
> > events to see if I could find out how high the section was but it 
> > always comes up with the original design height, not the height of 
> > the detail section with the expanded "Can Grow" text boxes.
> > 
> > So is there a way to know the height of the detail section at a 
> > point where I could still adjust the vertical line height to fill 
> > the section?
> > 
> > MTIA
> > 
> > Rocky Smolin
> > Beach Access Software
> > 760-683-5777
> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> > <http://www.e-z-mrp.com/>
> > Skype: rocky.smolin
> > 
> > --
> > 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
> 


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