>I've asked this question before, without resolution, but I've learned a lot
>more about different sorts of coding since then, and perhaps I can now ask it
[quoted text clipped - 20 lines]
>not next. I am convinced that this must be a relatively simple programming
>job, but I don't know how to do it.
I have no problem doing that.
Some things to keep in mind when doing this:
The Page header/footer sections can not grow or shrink so
you must make the page footer section and the subreport
control large enough to display it's maximum number of
records.
When the subreport is open in design view, make sure its
Width is small enough to display all three columns. Use the
File - Page Setup menu item to specify its number of
columns.

Signature
Marsh
MVP [MS Access]
r. howell - 28 Sep 2005 15:21 GMT
Here's what happens. I designed the subreport, very careful to specify
everything on the page setup field. I check that it works. No problem.
I put the subreport in the report field, and link it properly. There is
plenty of room for it to open with multiple columns.
I open the main report. It shows one record in the subreport.
I check the design. The subreport has reverted to one column. I change it
back to three columns. I check it. I save it. I save the report. I close
out and open the main report. It shows one record in the subreport.
When I check the design the subreport has again reverted to one column. I
have repeated this process numerous times. What am I missing?
You have actually succeeded in getting a multiple column footer on a single
column report?
> >I've asked this question before, without resolution, but I've learned a lot
> >more about different sorts of coding since then, and perhaps I can now ask it
[quoted text clipped - 34 lines]
> File - Page Setup menu item to specify its number of
> columns.
Marshall Barton - 03 Oct 2005 16:15 GMT
That sounds very weird and I have never seen that behavior.
The number of columns reverting sounds kind of like a bug in
A2000 that was fixed in the first Service Release. If you
are using A2000, check to make sure you have all the updates
installed.
And, Yes, I have what I think you are describing working
just fine so I am at a total loss to explain what you're
seeing.

Signature
Marsh
MVP [MS Access]
>Here's what happens. I designed the subreport, very careful to specify
>everything on the page setup field. I check that it works. No problem.
[quoted text clipped - 52 lines]
>> File - Page Setup menu item to specify its number of
>> columns.