[AccessD] Vertical line in detail section
Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jun 18 08:31:01 CDT 2016
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
>
More information about the AccessD
mailing list