Making my report look like a table

  • Thread starter Thread starter Ann M
  • Start date Start date
A

Ann M

Guest
I want my report to look like a table. I have turned on the "can grow" setting and have set the border style to "solid" (so the data is in boxes). My problem is that I want the table rows to expand, but so that it looks organized as a grid. Not a series of bigger and smaller boxes for each row. I hope this makes sense and I hope you can help!
 
You could try a crosstab or set all the border properties to transparent and add this code.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim CtlDetail As Control
Dim intLineMargin As Integer


intLineMargin = 60


For Each CtlDetail In Me.Section(acDetail).Controls
With CtlDetail

Me.Line ((.Left + .Width + intLineMargin), 0)-(.Left + .Width + _
intLineMargin, Me.Height)

End With
Next
With Me
Me.Line (0, 0)-Step(.Width, .Height), 0, B
End With

Set CtlDetail = Nothing

End Sub
 
bump!
this is awesome
 

Users who are viewing this thread

Back
Top Bottom