DoCmdOpenReport - DoCmd.OpenForm in Microsoft Access


	Back to DoCmd.OpenForm Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DoCmdOpenReport

Gary Becker

15 months ago

I really enjoy the TechHelp videos. I would like to see a a series of TechHelp videos on the OpenReport command. All the settings and code that controls how the report opens, where it opens on the screen, the zoom level and lots of other stuff. I like to open reports in Preview mode but so often it opens up little and hard to read onscreen.

	Kevin Robertson @Reply 15 months ago
Give the code in Richard's reply to this thread a try: Resizing report preview window

	Kevin Robertson @Reply 15 months ago
I would make it a Public Sub in a Module and send it the Report Name and an optional Where Condition. This works for me: `Public Sub OpenReport(ReportName As String, _ Optional WhereCondition As String = "") Screen.ActiveForm.Refresh DoCmd.OpenReport ReportName, acViewPreview, , WhereCondition DoCmd.MoveSize 100, 100, 15000, 15000 DoCmd.RunCommand acCmdZoom100 End Sub`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in DoCmd.OpenForm.

Next Unseen

New Feature: Comment Live View