If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sections of report too big for page width...
I have an Access database interface that contains forms based on a Medical
school application (links to tables on the SQL server) . The Admin office wants a print out of the completed application for each applicant... Very specific what section of the application goes on each page...so I have used page breaks 1st problem...some sections have blank pages between them? Is this a margin width problem? (I already have left and right margins set to .05") Most importantly...I had to use subforms for the report sections (instead of subreports)...because a lot of the info in the database is in datasheet view...couldn't choose datasheet view of data when using a subreport... 1. What is up with the boxes around the subforms?? Is there a way to get rid of them in the report? And...some forms have a lot of fields..(which is fine in the forms...because they can scroll to see the info...but not so in a report) .....so all the info cannot be displayed across the report page... I don't want to change the subform font...because those changes are reflected in the database forms... Any help greatly appreciated! |
#2
|
|||
|
|||
"jacqueline" wrote: I have an Access database interface that contains forms based on a Medical school application (links to tables on the SQL server) . The Admin office wants a print out of the completed application for each applicant... Very specific what section of the application goes on each page...so I have used page breaks 1st problem...some sections have blank pages between them? Is this a margin width problem? (I already have left and right margins set to .05") Ans: open your report in desing view and check that there is no blank space to the right of any fields, simply take the right border of the dising page and drag it to the left, don't worry, it will not overlay fields. if this does not solve your blank page probelm, you will have to reduce the width of some or all of the fields and possibly lines and boxes on the right side of the report and than again drag the right border to reduce the overall width. Remenber the total width is the width of the report in design view added to the margins set in the page setup. Most importantly...I had to use subforms for the report sections (instead of subreports)...because a lot of the info in the database is in datasheet view...couldn't choose datasheet view of data when using a subreport... 1. What is up with the boxes around the subforms?? Is there a way to get rid of them in the report? Ans: Set the border style to transparent in the properties window. And...some forms have a lot of fields..(which is fine in the forms...because they can scroll to see the info...but not so in a report) ....so all the info cannot be displayed across the report page... I don't want to change the subform font...because those changes are reflected in the database forms... Ans: you must set the width to the appropriate width as required however the window in which you placed the form, did you set its can grow property to yes? Any help greatly appreciated! Hope this helps. Fons |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Two-column report needs info across the page header width | Dan | Setting Up & Running Reports | 1 | October 18th, 2004 09:44 PM |
Width property | gr | Setting Up & Running Reports | 1 | August 21st, 2004 12:54 PM |
6 Tables, 1 Report, W/O 6 Qrys | Andy | Setting Up & Running Reports | 9 | June 29th, 2004 09:52 PM |
e-mailing sections of a report to specific e-mail addresses | tj | Setting Up & Running Reports | 1 | May 27th, 2004 04:19 PM |