Access Report Size Macro

[HanneSThEGreaT]

Hi guys, long time no see :)

At the college I'm workingat we have a Access 2000 - 2003 database that keeps track of all the students' marks, exam dates and overall progress etc.
This database is not designed by me ( I'd have done it way differently, but that's another story ).

Some of the students have many subjects, now this causes the certain report to print 2 pages instead of one - so the whole actual problem is the spacingof the Report details.

On the detail section we list the student's name, surname, ID, Course. Then we list each subject with the subject's start dates, end dates, and results. Lastly, we then, have a space where a representative of the college should sign.
It works, but the line where we should sign sometimes print on a separate page, instead of the same page. I hope you understand what I mean. :)

I want to know if it is possible to create a Macro ( or anything ) to prevent this - I've done a lot of research and the answer is mostly no.

What can I do ¿

Any help will be greatly appreciated. ;)

Hannes

[davide++]

Hi guys, long time no see :)

At the college I'm workingat we have a Access 2000 - 2003 database that keeps track of all the students' marks, exam dates and overall progress etc.
This database is not designed by me ( I'd have done it way differently, but that's another story ).



Hi Hannes.
Yeah, I remember...

Well, it's a bit difficult to imagine how your report is in detail, but I think that the problem arises when the list of the subjects is too long to be fitted into a page. Probably there isn't a solution, may be you can try to distribuite the subjects onto two pages with the same numbers of subjects, so the form will seem niciest.

[HanneSThEGreaT]

Hello again my friend!
This DB is a different one than this (http://www.codeguru.com/forum/showthread.php?t=398132&highlight=relationship) one, where you and jp helped me brilliantly :)

but I think that the problem arises when the list of the subjects is too long to be fitted into a page
Yes. You are right.
may be you can try to distribuite the subjects onto two pages with the same numbers of subjects, so the form will seem niciest.
This actually gives me an idea, Thanx! Perhaps if I choose a different Report Layout, like columnar or something... Let me try, and get back to you :)

[HanneSThEGreaT]

Nope. I don't come right :(
Isn't there any way at all to achieve this ¿

[George1111]

Hi Hannes

2 Options

1) Formulate the Report and export it to Excel - tell Excel to print 'fit to page' for reports which go just over the page - Best feature of this technique is that you finish the report before committing to paper (before sending to Excel) I normally create these reports using an MSFlexgrid, then export the grid to excel

2) Create a Form Design (not a Report Design) which has a friendly look and has sections with nice lines etc. eg, Something like an Invoice Form but with details suitable to your needs
I design these in VB6 using a landscape design. I use lines to create boxes, labels to layout my data, with right or left alignment, and also clever use of Fonts to dress it all up.
Once I fill in a form (Borderless Form), I then simply say Form1.Printform to generate the paper (or even PDF) output

VB6 is easier than .Net to do this as .Net doesnt (didnt have) a good PrintForm option (has it now ?)

Have a look at the attached PDF which was generated using this technique

[HanneSThEGreaT]

Thanx for th great ideas George!
I'll look into them, and get back to you :)

Thanx once again! :wave: