Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unwanted page breaks in Access Reports

Status
Not open for further replies.

pyrexial

Programmer
Feb 13, 2002
1
GB
Hi All,

I am doing something I have never tried before, but am experiencing MANY problems. What I am doing is linking an Access front end to SQL Server to churn out reports to a directory (giving them the .DOC extension). I then use a Word document with Macros to format the text and output it to another location.... The problem I am having right now is that the initial documents from Access have page breaks at the end of every page so that no sections are split over pages. How do I surpress that function so that it prints out coutinuous text? These breaks are ruining the formating of the final document! I have messed about with page headers/footers, grouping/sorting, force new page/keep together, but have had no luck. Please, please, PLEASE help.

Regards,
Gee
 
If I understand you correctly, the best thing to do would be to output an Access table, using a make table query, read that into MS Word. The table would have no page breaks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top