how do you control report preview size on open?

[gino]

when i preview my reports....they tend to open up in small windows.... i was wondering if anyone knew how to control the height and width of the report when being previewed. thanks in advance...

 

[MattGilbert]

You could try the following:

DoCmd.OpenReport "YourReportName", acPreview DoCmd.SelectObject acReport, "YourReportName"
DoCmd.Maximize

This should open the report full screen

 

[gino]

thanks....

 

[gino]

is there a way to control the actual size but not maximizing the whole window?

 

[MattGilbert]

This would involve one or more win API calls from within your code - I guess you would have to get the hwnd value for the report window and then programatically set the size. Not to easy...