scrolling through report using the mouse key?

[wjulaxer13]

I have a series of reports of reasonable length that I can move up and down using the arrow keys but I just haven't figured out how to set it up to use the mouse wheel. I am looking for ideas on getting this to happen. Thank you. :banghead:

 

[Ranman256]

the mouse scroll should be automatic, to scroll up/down on a page.
you CANNOT scroll across different pages. Only next record button does it.

 

[jdraw]

You may get some ideas from this article by Allen Browne.

 

[speakers_86]

Here is how I make a report move to the next page using a button in a custom ribbon.

            DoCmd.OpenForm "frmDummy"
            DoCmd.Close acForm, "frmDummy"
            RunCommand acCmdFitToWindow
            SendKeys "{PGDN}"

The opening and closing of the dummy form fixes an odd focus problem that sometimes occurs. The command ensures that you are not maximized. If you are, then you cannot go to the next page. The sendkey is how we actually move to the next page.