VBA MS Access Open Report in "Report View"

Question

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.

Accepted Answer

```
DoCmd.OpenReport "rptYourName", acViewReport
```

VBA MS Access Open Report in "Report View"

Solution

Problem