Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.OpenReport opens in print

Status
Not open for further replies.
jgd12345

jgd12345

Technical User
Apr 22, 2003
124
GB
When I run the command DoCmd.OpenReport... (in vba) it starts to print the report. Why won't it just open the report normally? I'd be greatful if anyone can help. Cheers
 
Sort by date Sort by votes
Hi!

Yes, when no view is specified, the acVievNormal is default, which means printing. If you want to preview, try using the acViewPreview argument:

[tt]docmd.openreport "myrpt",acViewPreview[/tt]

Roy-Vidar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
700
PrimoSteve
PrimoSteve
Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
449
Xavierparkash
Xavierparkash
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
743
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top