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.
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.
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
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.
Access Report Size Macro
Reply With Quote
Originally Posted by HanneSThEGreaT
