Hi,
I'm trying to create a subreport that lists the entries down and then across
for a few reasons. The primary reason is I want the items to be listed
alphabetically going down and then across (to match a previously made paper
form). Also, the space is limited vertically that the subreport can fill so
I wanted to set the height property under the column size. However, when I
do all of the above, the subreport only comes out in one column. I can get
the multiple columns if I do the "Across then Down", but then the items are
not in the correct order. Any ideas? Thanks for the help.
Rick Brandt - 31 May 2006 00:29 GMT
> Hi,
>
[quoted text clipped - 7 lines]
> columns if I do the "Across then Down", but then the items are not in
> the correct order. Any ideas? Thanks for the help.
You cannot use Down, Then Across in a subreport that also has CanGrow set to Yes
on the subreport control. The subreport does not "know" when the parent report
has hit the bottom of a page and that is why you get one continuous column. It
does know when it has hit the bottom of the subform control (if CanGrow = No).

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com