[AccessD] Vertical line in detail section
rockysmolin at bchacc.com
Sat Jun 18 14:24:06 CDT 2016
Tried that but the detail section is a sub Report. :) So no page event
triggered on the sub-report. On the main report's page footer the line
doesn't butt up against the bottom of the vertical column separators.
On the bright side the client seems to have unlimited patience and budget
while I figure this out.
But your post gives me an idea to try getting rid of the sub report and just
bringing the detail data into the main report. (Not sure why I made it a
sub-report in the first place.)
So...stay calm and code on!
Beach Access Software
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Roberto Ford Long
Sent: Saturday, June 18, 2016 8:22 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Vertical line in detail section
I use page-footer section, and put a line on top of if.
Em 18/06/2016 11:55, Rocky Smolin escreveu:
> 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.
> -----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
> 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.
> 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
>> 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
>> Rocky Smolin
>> Beach Access Software
>> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
>> Skype: rocky.smolin
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> Website: http://www.databaseadvisors.com
AccessD mailing list
AccessD at databaseadvisors.com
More information about the AccessD