Columnar Printing

[sparklegrrl]

I need to print a report of all of the cars in our facility at a certain time and have created the query.

The problem is I need it to take the data and if let's say the list is longer than 3" of the page on the report, I need it to throw it into columns so that it all prints in the middle of the page in columns.

 

[Fornatian]

One approach is to open a different report if your query has more than X records. If for instance the list was displayed on the current form in a list box you could do...

Dim lngCrucialFigure as Long
Dim rptName as String

lngCrucialFigure = 300

If Me.MyListBox.ListCount > lngCrucialFigure then
rptName = "ColumnarReport"
Else
rptName = "NormalReport
End if

Docmd.OpenReport rptName

 

[sparklegrrl]

How would you make the 2nd report display the data in columns?

 

[Fornatian]

Take a look at the Solutions.mdb (on my computer stored at C:\Program Files\Microsoft Office\Office\Samples\Solutions.mdb) which has an example of a multiple column report and a step by step of how to create it. Select 'Create Advanced Reports' from the upper list and 'Create a Mutil-Column Report' from the lower list and OK

 

[sparklegrrl]

THANKS SO MUCH! I found it...now I just have to get the Northwind DB but I will DEFINATELY check it out! THANKS SO MUCH!