[AccessD] Vertical line in detail section

Rocky Smolin rockysmolin at bchacc.com
Sun Jun 19 11:21:04 CDT 2016


Thanks JD.  I made some progress and I'm hoping the client buys off on
having the horizontal lines between the details instead of insisting that
they go away.  

I did generate another issue though in the process of drawing those vertical
lines in the Format event and that is that one of the fields has to be wide
enough so that it overlaps a couple of the vertical column divider lines.  

The text box has Back Style Normal so I was hoping it would be in front of
the vertical lines and the lines wouldn't cut through the text in the box.
But since I'm drawing those line using the Line function apparently they end
up in front of the text box regardless of what I do in the design more.  And
BrigToFront in VBA is not available at run time. 

Any ideas how to get those lines behind the text box?

MTIA

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Sunday, June 19, 2016 8:38 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Vertical line in detail section


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