Vertical Line grows when when fields grow

[trident]

I have followed the below code i found in the net for the vertical lines, this code is for Access 2013

Private Sub detail_Print(Cancel As Integer, Printcount As Integer)
Dim Ctldetail As Control
Dim intLinemargin As Integer


intLinemargin = 0


For Each Ctldetail In Me.Section(acDetail).Controls
With DtlDetail
If Ctldetail.Name = "Line123" Then
Me.Line ((.Left + .Width + .intLinemargin), 0)-(.Left + .Width + intLinemargin, Me.Height)


End If
End With
Next


Set Ctldetail = Nothing
End Sub

I change only the name of the line, can this be used for Access 2010, when I used the same a gap on the line is showing.

Can you help me please.

thank you.

Trident

[CJ_London]

don't see why not, the functionality has been around since 2003 - suspect you haven't changed all the control names - these are referring to different controls

With DtlDetail
If Ctldetail.Name = "Line123" Then
Me.Line ((.Left + .Width + .intLinemargin), 0)-(.Left + .Width + intLinemargin, Me.Height)

and if you are only referencing one line, then you do not need the loop, just refer to the control directly

[trident]

Thank you for the reply, just need to clear some things on read

DtlDetail - should this be a form name or will stay as is?
Ctldetail.Name - the .Name should be change to my form name?
Me.Line - the .Line should change to my line name?

Trident

[CJ_London]

I think they should all be ctlDetail but suggest you post your original unaltered code or a link to where you got it from - at the moment, although I understand the principle of what you are trying to do, the code you are using seems unnecessarily complex and perhaps is intended to do something more. Also, please use the code tags (the # button) around the posted code to preserve indenting - although not long, your unindented code is difficult to read and I don't have the time to spend trying to figure it out

[CJ_London]

also to be clear, the line function is only available for reports - you are referring to forms - in which case abandon now.