Problems with report

J

jacqueline

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 to create a report that details all the different
sections of the application...so that the interviewers will have a copy of
the applicants info in fron tof them during the interview process.
Want 1 section on each page...I used page break after each section...but
some pages are printing a blank page btw section...margin isn't set too wide
for the page either?? Any ideas...

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 I added a subreport...

The problem is there are boxes around the subforms on each page (how to get
rid of that?)
And...some of the forms have way too many headers...so all the info cannot
be displayed in the report section...I don't want to change the subform
font...because those changes are reflected in the database forms...(there you
can just scroll over to see the rest of the headings and info...)

Any help greatly appreciated!
 
Top