ACCESS FEED: Re: [MS_AccessPros] Detail section Vertical line

Kamis, 02 Februari 2012

Re: [MS_AccessPros] Detail section Vertical line

Duane

I do that but nothing have happened, this was my second question , first one was about removing the tiny blank space at the starting point of lines.

Thanks & Regards,
--
Abdul Shakeel

________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Thursday, February 2, 2012 6:30 PM
Subject: RE: [MS_AccessPros] Detail section Vertical line

Abdul, I think you have two questions but I'm not sure what the first one is. If you want the line height to be a constant 5 inches then change the 14400 to 7200. Duane HookomMS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: abdul.shakeel@yahoo.com
Date: Thu, 2 Feb 2012 05:16:33 -0800
Subject: [MS_AccessPros] Detail section Vertical line

Hi All,

I am using the following code in my reports detail section

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Me.ScaleMode = 1

Me.ForeColor = 0

Me.Line (0.0208 * 1440, 0)-(0.0208 * 1440, 14400)

Me.Line (0.625 * 1440, 0)-(0.625 * 1440, 14400)

Me.Line (3.1458 * 1440, 0)-(3.1458 * 1440, 14400)

End Sub

Lines are printed pretty well but the vertical position of the line is little out mark mean lines are printed beneath the detail section let say if one my control height is 1.5 (with top set 0) the line top property would 0.02 or more aprox. secondly how I can control the height of the line I want fixed height line to be printed let say 5 in.

Thanks & Regards,

--

Abdul Shakeel

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]