[AccessD] Vertical line in detail section

Bill Benson bensonforums at gmail.com
Mon Jun 20 16:14:51 CDT 2016


Can you believe my company policy has blocked me from looking at the 1st
two websites?! They do that with one of the major excel forums too.

On Sun, Jun 19, 2016 at 11:37 AM, Jim Dettman <jimdettman at verizon.net>
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
>


More information about the AccessD mailing list