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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/