i have a report that is based on a query, the setup is a date is selected on a form using the date picker, then a button is pressed to open the form.
how do i get it to load up full or at 100%, to save the enduser from doing this everything
thanks
i have a report that is based on a query, the setup is a date is selected on a form using the date picker, then a button is pressed to open the form.
how do i get it to load up full or at 100%, to save the enduser from doing this everything
thanks
Did you mean button is pressed to open 'report'? Do you really want 'zoom in'? Or do you want the report to display the entire page on open?
I find that my reports always open at the same zoom level I last saved them. So I open each report in ReportView at 100% view then click save then close report. Since my users cannot make design edits, this serves my requirements.
But try:
DoCmd.RunCommand acCmdFitToWindow
or
DoCmd.RunCommand acCmdZoom50
The latter command has 9 variations of the number.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
thanks ill try it out, for some reason iam not getting the email replies the thread has been answer, any ideas.
i have tried both the commands, and the second one DoCmd.RunCommand acCmdZoom100 is working. the report is shown at 100% but the window size is limited, so i had to drag the window to beable to see the report. is there a command to make the window 100% too. i have attached an image when the report is opened.
![]()
If you have profile set for email notification and your email is not sending to junk, should see them. You could try a thread in forum support. Maybe the administrator will respond.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The only command I know is to maximize the object. This setting will apply to all subsequent objects opened unless you set back to what it was.
See what you can find with Google: Access VBA report window size
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i have had a look online, lots of results on how to zoom in which you already have given the code to, but nothing to say how to simply make it full screen!?
Full screen would be setting Maximize method.
DoCmd.Maximize
As stated, that will apply to all objects, it is an app setting.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
the best way is to open the report in report view rather then using print preview or other view, in the vba coding just change the standard code with ", acViewReport" at the end, the code with an example is:
DoCmd.OpenReport "rpt_CallList", acViewReport