C
ccameron
How can I print a form with tabs so that all tabs are visible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
molsonexpert
ccameron said:How can I print a form with tabs so that all tabs are visible?
Other than by doing a print screen, I don't think this is possible. Why do
you want to print a form?
D
Douglas J. Steele
Forms aren't intended for printing: that's what Reports are for.
G
Guest
I use this code in a Command button, On Click. Substitute Primary key with
yours.
Dim strWhere As String
If Me.Dirty Then 'Save any edits first
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[PrimaryKey] = " & Me.[PrimaryKey]
DoCmd.OpenReport "AccountForm", acviewPrint, , strWhere
End If
yours.
Dim strWhere As String
If Me.Dirty Then 'Save any edits first
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[PrimaryKey] = " & Me.[PrimaryKey]
DoCmd.OpenReport "AccountForm", acviewPrint, , strWhere
End If