Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

VBA MS Access Open Report in "Report View"

Is there a command to open a report via VBA - currently I've used the docmd acViewPreview but this doesn't really solve the problem as the print preview does not give you a very good view of the report on your computer. What I need is the "Report View", just as one would do if they "double clicked" the report from the navigation pane.

It seems like this should be super easy, appologies, I'm used to working with forms more than reports.

Thank you in advance.

like image 241
Dm3k1 Avatar asked Dec 26 '22 00:12

Dm3k1


1 Answers

DoCmd.OpenReport "rptYourName", acViewReport
like image 153
Andy G Avatar answered Jan 14 '23 13:01

Andy G