UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Report View Vs Print Preview In 2010, Office 2010    
 
   
Brandi
post Apr 11 2012, 11:19 AM
Post #1

UtterAccess Guru
Posts: 931



I have placed a button on a form which should open a report in Print Preview; however it opens in Report View where you don't see all the formatting.
The event code created by the button tool uses acPreview. I did some research and found another version that was acViewPreview. Neither of these will open my report in Print Preview.
Does anyone know what I need to use to keep it from opening in Report View and instead in Print Preview?

Thank you.
Brandi

The event code is as follows:
Private Sub btnTalentSnapshot_Click()
On Error GoTo Err_btnTalentSnapshot_Click

Dim stDocName As String

stDocName = "rptTalentSnapshot"
DoCmd.OpenReport stDocName, acPreview

Exit_btnTalentSnapshot_Click:
Exit Sub

Err_btnTalentSnapshot_Click:
MsgBox Err.Description
Resume Exit_btnTalentSnapshot_Click

End Sub
Go to the top of the page
 
+
 
Start new topic
Replies
darnellk
post Apr 11 2012, 11:42 AM
Post #2

UtterAccess Veteran
Posts: 304
From: Edmonton, Alberta, Canada



Have you tried setting the "Default View" in the Report's properties to "Print Preview" instead of "Report View"?
Go to the top of the page
 
+

Posts in this topic


Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 01:04 AM