Ms-Access Reports how to setup

[Mohsin Malik]

I am working in ms-access 2010 reports, i have a screen resolution in my Laptop 1920 x 1080, while designing report for both printable and view, i want ms-access to automatically set all fields according to the screen resolution size for viewing, while printing i want to set fit to one page as default? Is there any built-in-option in reports? As i have saw that in forms we have a option of every control for Vertical Anchor and Horizontal Anchor to set according to the screen resolution, Please help how can i do this?

 

[Pat Hartman]

Sadly, Access doesn't have a "fit to page" options like Excel. Reports need to be designed to fit within the constraints of the paper size you want them to print on. Because of client demands that a particular report always print "fit to page", I've had to use Exce to accomplish that.

The first time I had to do this, the report was complicated (of course, or this wouldn't be a problem) with lots of calculated controls. Rather than recreate the whole thing in Excel, I added code to the Print event of the Detail section to just copy the calculated control values to specific cells in the worksheet. The report header stuff was pushed to Excel from the Report's Load event. The final totals were pushed from the Report footer. Then I selected the sheet and printed it using size-to-fit.

If you are not Excel savy (It gives me a headache but it's far easier to automate than Word), you can usually use the macro recorder to record actions and then copy the generated VBA into your Access database. Some changes are required because the object references are different when you refer to objects from within Excel VBA rather than from outside with Access VBA.