Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / May 2006

Tip: Looking for answers? Try searching our database.

Multi-column subreports - down then across

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shaun - 30 May 2006 22:56 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.