How do i change Report size in access 1013

[sam02]

Hi can I ask is it possible to open an access report open a little larger than it does now.



When I open a report it displays a report box with the report visible inside as I would expect but the box with the report inside is a little small and I would like to make it larger as the report has quite a lot of data on and it’s difficult to read.

I have tried the going into the Event Property and opened the Ellipses and in the code builder added the DoCmd.Maximize, to on open and this does open the report in full screen.

But then on the bottom of the report I lose the page scroll bar so I am not able to move pages in the report

I can right on the bottom use the scroll bar to alter the report zoom size and this alters the size of the report inside the box but the box stays the same size

So is it possible to make the box open to a larger size please

PS I am not too good with code its only what I have read on the internet

[ranman256]

In design mode, select all, increase the font,
or
set the Zoom to a larger number in print preview.

[sam02]

Hi thank you for the advice i have tried both ideas and yes the report is bigger and easier to read but as it gets bigger i see less of the report as the window the report is in is the same size, what i am trying to do is make the window the report is in bigger if that is possible

[jwhite]

There is a great solution here: http://www.utteraccess.com/forum/ope...-t2003258.html

[sam02]

Thanks jwhite thanks for the link

But it is above me i just dont understand about code very much

I just dont see why it should be so hard to resize a window and have it reload to the same size next time it is opened

[jwhite]

To my knowledge reports can not be sized like forms can be. Give that PreviewAndZoomReport() function a try posted by R. Hicks. You can set the zoom size of the report with any percentage you want.