Multiple Column Report with Columns Longer than Page

[Guest]

I'm working on a multiple column report. There is one column for each
facility, with labels in the first column. As long as the columns are
shorter than the height of my page, it works fine. I'm using VB to hide the
text boxes and display the labels in the first column and vice versa in the
following columns.

I need to change the orientation of the report from portrait to landscape.
I would like to split the report into two pages, with the bottom half of each
column on the second page. Currently, if the column layout is set "Down then
Across" I get the bottom records in each column appearing at the top of the
next column. If I switch to "Across then Down" I get nothing. The status
bar says "Formatting Page, press ctrl+break to stop", the progress bar goes
all the way across, and then zip. It hangs until ctrl break is pressed.

I'm using Access 2003, and the data source is a simple query. It looks like
the VB is stuck in a infinite loop but I can't see what's causing it. Any
suggestions?

 

[Guest]

Bueller? Bueller? Anyone? I'm still running into a brick wall here. I
don't want to split this into two separate reports since that would mean two
separate snapshot files every time. Ideas? Thoughts? Help?


Nick