3 Page Form (1 Viewer)

[Tina Brev]

Hello,

I have a 3 page form that is a copy of one of our Word document.

When I do a print preview:

On page 1, some of the data are being cut-off

On page 2, half of the data are being repeated in page 3

Therefore, the beginning of page 3 is in the middle of the page

Frustrated

 

[pdx_man]

Things that are to be printed are better off being done in a report. You have better control of positioning, page breaks, grouping ... give that a try.

Behind a command button, have code:
Private Sub Command30_Click()
dim WhereStr as String

'Assuming you have a primary key field for uniqueness (I'm calling it ID)
WhereStr = "ID = " & Me.ID

DoCmd.OpenReport "Rpt_TheName", acViewPreview, , WhereStr
End Sub

 

[Tina Brev]

Hello,

Thank you for your reply. Unfortunately report will not do the job for me for I have controls in the form that requires input from the user and I don't think a report will give me that capability (unless you tell me otherwise).

This form/template is going to replace our Word document eventually.

The code that you gave me, will that work for my form also?

Thanks