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 / April 2008

Tip: Looking for answers? Try searching our database.

Need help on Complex report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leif - 28 Apr 2008 19:12 GMT
I've already left a message or two on this complex report and I appreciate
all the help.  However, I've run into another issue.

I have a form like report and has an embedded table.  The previous issue was
the breaking of a text field between two pages.  This was resolved by placing
each question/answer of the table in its own separate group.  That works fine.

The top of the page is to be shown on each page.  I do that by placing it in
the page header section.  Below the page heading is a section of text that
only needs to be shown once per record.  A record may span 2-3 pages
depending on how much text is placed in the answer (each section is set to
can grow).

After this text is the table header, which again should be shown at the top
of each page.  I do that by placing the table header in its own section and
marking it as repeat.  I also set the record key for the Grouping section.

Everything works fine, except a new record does not generate a page break as
I expected.  I can set the table header section to break before section,
however, that causes a problem on the first page of the report.

I possibly could use a break object and turn it off/on based on some
condition in VBA.  However, I don't know what condition I could test for in
VBA.

Thanks for your help.
Evi - 28 Apr 2008 19:27 GMT
Does it work if you use Force New Page - After Section, in the *Group*
footer (ie not the report or page footer)?
Evi
> I've already left a message or two on this complex report and I appreciate
> all the help.  However, I've run into another issue.
[quoted text clipped - 22 lines]
>
> Thanks for your help.
 
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.