RIGHT most line VBA for Detail_Print

[hollyanneu2]

Since I am not too familiar with Access VBA programming but am learning. I do have one that I need help with. What I need is the RIGHT most line. I have the LEFT and the between lines but not the RIGHT. I cannot change the Integer 1 to "8" because there is a hidden field in there.

Will you please help me! And even explain what 'left most line Me.Line (0, 0)-Step(0, lHeight), lDarkGray in red means? Like (0,0) and so on?


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


Dim lDarkGray As Long: lDarkGray = 3355443
Dim lWidth As Long: lWidth = Me.Width
Dim lHeight As Long: lHeight = Me.Height
'left most line
Me.Line (0, 0)-Step(0, lHeight), lDarkGray
'the rest of the vertial lines
Dim i As Integer
For i = 1 To 7 Step 1
Me.Line ((Me("txt" & i).Left + Me("txt" & i).Width), 0)-Step(0, lHeight), lDarkGray
Next i
'bottom lines
Me.Line (0, lHeight)-Step(lWidth, 0), lDarkGray
End Sub

[NTC]

very very few people these days manipulate printing via code........are you sure you need to really? are you familiar with the page layout properties of the report object?

[hollyanneu2]

Unfortunately the company I work for STILL uses 2003 Access and I inherited a database that produces the letters due on May 1st that I got to get done....These were written from previous developers no longer with the company And as far as page layout properties of the report object - I am getting there but still learning.