Converting from a pre-printed form

[crowegreg]

I've converted my customer from Access 2003 to Access 2010. In doing so, we've lost the function of a dot matrix printer. I previously designed a report that printed on pre-printed forms. The pre-printed forms had column lines separating each field being printed. I've added vertical lines in the detail area separating each data field. All the lines are aligned as needed. My problem is I need the lines to extend all the way to the footer of the report. Is this possible?




Thanks in advance!!

[June7]

Review: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

This code works for me. The unit of measure is TWIPS, 1 inch = 1440 TWIPS. The lines will draw only in PrintPreview or direct to printer:

Private Sub Report_Page()
Me.Line (1.5 * 1440, 100)-(1.5 * 1440, 14000), vbRed
Me.Line (4.5 * 1440, 100)-(4.5 * 1440, 14000), vbRed
Me.Line (6.5 * 1440, 100)-(6.5 * 1440, 14000), vbRed
End Sub

You can use line objects on the report to help you get the position measures for the code.

[crowegreg]

Very nice. Thank you!!

I pasted your code and the code from the reference page.

Can you help me get started? My first line has these settings within the properties:
Top: 3.125I
Left: .7917
Length: .4

How do insert these into your line of code?

[crowegreg]

I figured it out. Here's my final code:
Me.Line (0.7917 * 1440, 4500)-(0.7917 * 1440, 12595), vbBlack
Me.Line (1.9333 * 1440, 4500)-(1.9333 * 1440, 12595), vbBlack
Me.Line (2.325 * 1440, 4500)-(2.325 * 1440, 12595), vbBlack

Thanks again for your assistance!!