Sendkeys replacement code

[Guest]

Hello,

In Access 2003 I have a vba module that runs when a report is opened that
uses 2 different Sendkeys commands, one to fit the report to the window
(SendKeys "%vzf") and one to advance the report pages to a specific page
based on a counter (SendKeys "{RIGHT}"). Since the Sendkeys command does not
work properly in Vista, I am looking for the proper VBA code to carry out
these actions - fitting the report to the window and advancing the report a
certain number of pages.

Any help you can provide is greatly appreciated.
Thanks.

 

[Guest]

For the first one:

DoCmd.MoveSize 1, 1, 14500, 9000

It doesn't really fit to screen so it helps if everyone uses the same screen
resolution.