Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2006

Tip: Looking for answers? Try searching our database.

Print Vertical Line

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vensia - 09 Jan 2006 08:09 GMT
Dear all,

My report has layout like this :
- Report Header
- Page Header
- InvoiceNo Header
- Detail
- InvoiceNo Footer
- Page Footer
- Report Footer

The user can use A4 or letter or half letter size to print the report.
I want to print vertical line using Line method from the top of InvoiceNo
section (or bottom of Page Header) until .Top of Page Footer. The report
height can be vary, depends on the paper size and bottom margin.
How to write the code ?
Thanks in advance.

Vensia
Marshall Barton - 09 Jan 2006 16:13 GMT
>My report has layout like this :
>- Report Header
[quoted text clipped - 10 lines]
>height can be vary, depends on the paper size and bottom margin.
>How to write the code ?

I don't have all those paper size options, but I think this
will work:

Me.Line (3000, Me.Section(3).Height)-(3000, _
        Me.ScaleHeight - Me.Section(4).Height), vbBlue

Signature

Marsh
MVP [MS Access]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.