report page layout

[firecop1]

I have a report with a few short fields and a then a memo field that can span from 1-3 or more pages depending on the incident.

I tried using a page break to insure that each record within the report will start on a new page. This works fine but the problem is that I am getting a blank page between each page of the report.

How and what do I have to adjust to correct the problem.

Also, I would like to place a button on my form that will enable me to print a report on the current record only. How would I do this?

Thanks to all in advance for your help.

AJ

 

[ZmrAbdulla]

Try playing with "force Newpage"

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[Pampers]

Hi Firecop,
For Printing (or Preview) the current record on form, use something like this:

Private Sub cmdInvoices_Click()
    Dim stDocName As String
    Dim stWhere As String
    
    stDocName = "rprtInvoices"
    stWhere = "VoyageID=" & Me.VoyageID
    
    'printpreview rprtInvoices where VoyageID = VoyageID 
     on form
    
     DoCmd.OpenReport stDocName, acPreview, , stWhere

End Sub

Pampers.

You're never too young to learn