Setting Height and Width with VBA

[MatthewR]

Good morning, everyone. I'm trying to use VBA to set the height and width of my reports. I've tried 3 different things in the Report Load event, and none have worked. This got me an error message:



Me.InsideWidth = 8 * 1440
Me.InsideHeight = 6.2 * 1440

These didn't give me an error message, but they didn't work either:

Me.Width = 8 * 1440
Me.Detail.Height = 6.2 * 1440

and...

DoCmd.MoveSize 1100, 550, 8, 6.2

Any idea what I'm doing wrong here? Thanks for your help.

Matthew

[pbaldy]

I'm curious why you'd set them in code rather than design view, but you might try the open event rather than the load event, which may be too late.

[MatthewR]

Thanks very much for the reply. I should actually clarify that I want to set the size of the window, not the report itself.

Unfortunately, putting the code in the the Open event did not work either. Do you have any other ideas, perhaps?

[pbaldy]

Oh, then probably no code in the report. You can try MoveSize in the code that opens the report, though I've never tried it with a report. I usually maximize reports. If you size the window once it's open, will it hold that size the next time it opens? Forms do that, haven't checked with reports.

[pbaldy]

By the way, what is the setting in File/Access Options/Current Database for document window options? It should be overlapping windows instead of tabbed documents I suspect.

[MatthewR]

Thanks for the reply. Unfortunately, I tried using MoveSize in the Open event, and it did not work.

And if I resize a report window manually, that size will not hold next time I open it.

And you are correct, it is overlapping windows, not tabbed.

[pbaldy]

I mentioned the code opening the report, not the report's open event.

DoCmd.OpenReport...
DoCmd.MoveSize...

[pbaldy]

Oh, and MoveSize uses twips, not inches.

[MatthewR]

Ah, excellent. That works. Thank you very much.

[pbaldy]

Happy to help!