Sections of report too big for page width...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jacqueline - 20 Oct 2004 16:27 GMT

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!

Reply to this Message

Fons Ponsioen - 21 Oct 2004 18:25 GMT

> I have an Access database interface that contains forms based on a Medical
> school application (links to tables on the SQL server) .
[quoted text clipped - 5 lines]
> 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

Reply to this Message