Creating tables for a report

[nblade]

Hi again,

Does Access have a built in method for creating tables in a report? The only option I see is to use the Line tool and manually draw a table.

Thanks

 

[KeithG]

You could use a Tabular sub report for your table.

 

[Compressor]

Or maybe create a subform which is displayed in datasheet mode based on the table/query which hold the values you want? Datasheet mode with a couple of head(er)s above it, or if that isn't possible use some labels, should represent a table quite nicely.

 

[Rich]

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