VBA MS Access function to reduce page size of report to printable A4 size.
4795
£300(approx. $377)
- Posted:
- Proposals: 5
- Remote
- #58799
- Archived
Description
Experience Level: Expert
Reports created in MS Access become too wide for printing on one A4 page.
A VBA function should be developed that will reduce all items on the report,
including font size,
and then move them closer together and reduce the page width,
so that the report fits into an A4 size for reduced printing. Either landscape or portrait.
This must give similar result as "fit to 1 page wide to n pages tall" in MS Excel. But may specify reduction to specified percentage.
Should preferably be compatible with MS Access 2000 to 2003.
The problem is that a large quantity of information must fit into the report. When it is designed using regular and readable controls and fonts, it prints over several pages (2 wide x 2 tall).
If initially designed to fit into A4 size, controls are so small that they are unreadable.
The idea is to design a report without regard to print size and then when all info is in place, then calling the function and the report will be reduced to A4 size.
Attached two MS Excel generated reduced reports. The required function must assist in creating similar reduced outputs with MSAccess.
A VBA function should be developed that will reduce all items on the report,
including font size,
and then move them closer together and reduce the page width,
so that the report fits into an A4 size for reduced printing. Either landscape or portrait.
This must give similar result as "fit to 1 page wide to n pages tall" in MS Excel. But may specify reduction to specified percentage.
Should preferably be compatible with MS Access 2000 to 2003.
The problem is that a large quantity of information must fit into the report. When it is designed using regular and readable controls and fonts, it prints over several pages (2 wide x 2 tall).
If initially designed to fit into A4 size, controls are so small that they are unreadable.
The idea is to design a report without regard to print size and then when all info is in place, then calling the function and the report will be reduced to A4 size.
Attached two MS Excel generated reduced reports. The required function must assist in creating similar reduced outputs with MSAccess.
Fritz P.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
4 May 2024
South Africa
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies