Display line when...

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a report that changes the background color of a group. Now what the
user would like is to display a line at the bottom.
Here is my code to change the back color also my line is at the bootom of
the Detail seciton and is called BottomLine.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If FormatCount = 1 Then
lngColor = IIf(Me.txtGroupCount Mod 2 = 0, vbWhite, 12632256)
If Me.Section(acDetail).BackColor <> lngColor Then
Me.Section(acDetail).BackColor = lngColor
End If
End If
End Sub

What I would the user would like to see is something like this....

AB123 ZF345 Dan Smith Replacement 2000
Contract Ext
450
 
"line at the bottom" where/which section? Have you tried using a simple line
control?
 
From the example you can see where the user would like the lin (at the bottom
of each group in the detail section) or basicly when the back color changes
color they want a deviding line.
I have not tried a simple line control, but will see what that is and if it
will work.
 
The line control can be found in the toolbox in report design. I actually
more often use a rectangle control with 0" height.

Keep in mind the bottom of one section is generally the same as the top of
the following section.
 
Thanks, figured it out...I needed to put it in the group footer for it to
only show up at the end of a group.
 
Back
Top