Lines on Reports?

[alexi]

Is there any way to get a table type lines on to a report
for example, in the detail section on a report, i have each line repeating. i need each line to be in a row with a line, and each column a column line. It is proving to be very difficult. Could just be me though

Any help appreciated.

 

[Rich]

Add the following code to the rport
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

 

[gdanalakshmi]

I have a table whose data I want to feed to a report. I am doing it through the code since the table is generated dynamically. I am able to print only the last record, & not the previous records.
How do i display all the records?

 

[alexi]

query

try using a query instead of a table for your report. this should work. and it will allow you to add where conditions etc.