formatting a report into columns

[Jim W]

Is it possible to format the detail part of a report into a column? If so
how?

Jim

 

[WayneRyan]

Jim,

Need more info here. Do you mean that you want to display the fields in
a Detail Record vertically?

Field1
Field2
Field3
.
.
.
Field1
Field2
Field3

Or:

[ParentRecord1Field1] [Parent1RecordField2] [ChildRecord1]
                                            [ChildRecord2]
                                            [ChildRecord3]
[ParentRecord2Field1] [Parent2RecordField2] [ChildRecord1]
                                            [ChildRecord2]

Wayne

 

[Pat Hartman]

Use the Page Setup option under the File menu.

 

[amoona]

Hi,

i've asked this question a few weeks ago and i got this solution from 'Rich' which works great for me:

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

 

[Jim W]

Wayne - I'm looking for the second part of your replay. I'm trying to compare
differences between configurations of system settings and the systems are a variable that users select from. So I want the report output to look like this

-------- System--System2
Config 1--setting--Setting
Config 2--setting--Setting
Config 3--setting--Setting
etc. etc. etc.
and other cases there can be more then 2 systems

-------- System--System2--System3
Config 1--setting--Setting---setting
Config 2--setting--Setting---setting
Config 3--setting--Setting---setting

and so on for as many configurations as entered.

Jim

 

[WayneRyan]

Jim,

If this is a Parent/Child type of report, look at the Sample Databases
forum. I posted a database that might help.

I'll look in later,
Wayne

 

[WayneRyan]

Jim,

This one:

http://www.access-programmers.co.uk/forums/showthread.php?t=70399

Wayne