[AccessD] Vertical line in detail section

[Jim Dettman]

 Yes, that was quite the surprise after all these years.

 Up until then, it was either try to do things in-line with the sections, or
the OnPage event, which is limited.

 There is one problem with it though; Access still balks of the page size -
margins - page header - page footer < 0.

 So it might not work in every situation, but the couple times I've tried
it, it's worked pretty well overall.  The last thing I did, which was a VICS
Bill Of Lading, came out pretty nice.

Jim.

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

Jim,  

Thank you for those links.   Your comment in the second one from 2012 was an
eye opener!

"I think the major thing to walk away with from this is the fact that you
can address the entire 
page in a header event and with .movelayout false, continue on down the page
overlaying 
anything you've placed on it.

That's never been obvious to anyone before and opens up the door for a wide
range of 
things.  For example, placing a water mark on the page."



-- 
Stuart



On 19 Jun 2016 at 11:37, Jim Dettman wrote:

> 
> Here's a link to the original thread on EE:
> 
> https://rdsrc.us/M8O57q
> 
> And here's the link to the article, which is well worth the read.  
> Great technique to use in general.
> 
> How to underlay a section in Microsoft Access Reports
> https://rdsrc.us/RcePO2 
> 
>  and a link the to Lebans print class for drawing lines in the On Page
> event.
> 
> http://www.lebans.com/PrintLines.htm
> 
> Jim.
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Jim Dettman Sent: Saturday, June 18, 2016 05:34 PM To: Access
> Developers discussion and problem solving Subject: Re: [AccessD]
> Vertical line in detail section
> 
> Rocky,
> 
> A couple of tricks here:
> 
> 1. You can grab the start of the detail section at the end of the page
> header and get the end of the details section starting with the page
> footer. Then draw a line in the on page event after everything is been
> placed.
> 
> Leban had a class module for doing this.
> 
> 2. But a really slick trick (and this is absolutely great for
> preprinted forms), is to underlie the entire page in the page header
> event with an image.  
> 
> I did this with a VICS BOL and it worked well.  There is an article on
> EE which I'll get a link for to point you towards.
> 
> The technique is simple though; put an image the size of your entire
> page in the page header event and then set move layout equal false. 
> You also need a dummy had her group to soak up the actual heading
> height.
> 
> Jim
> 
> 
> 
> Sent from my iPhone
> 
> > On Jun 18, 2016, at 8:40 AM, Rocky Smolin <rockysmolin at bchacc.com>
> > 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