Scroll down by code in reports

[petko]

This is a regular problem when opening report for which I could not find solution so far.

I use DoCmd.MoveSize for sizing and positioning the report's window and ZoomControl for the needed scale.

After opening the report this way manual scrolling is needed to scroll done from the header to the relevant data part of the report that are often out of the display. I'd like to save this manual action by setting a scroll value from code at opening so the report scrolls to a position where relevant data can be see at glance.

Is there a way to do this?

Appreciate your time!

 

[JHB]

In what mode do you open the report, "Report View" or "Print Preview"?

 

[MajP]

http://www.lebans.com/SelectRow.htm

In the past I have used some of the Leban's API stuff for controlling scrolling. You can download the code still. Likely have to update the function declaration with "PTRsafe" if running in 64 k.

 

[petko]

Most of the time in Print view but from time to time Report View is also used.