2 hopefully simple questions

[rgreene]

I'm fairly new to reports inside access and I have 2 questions.

1. I have taken an 4 page appraisal form and created it in Access. When I design the report I can only get the body section of the report to 22" which interns prints on 2 pages. I have another page I need to add but I can't get thebody section any bigger to add the remaining page. Is there a way to force a page break inside the body of the report. I can't use force new page before/after feature because I understand it that is for a section. Everything I have is in the Body section of the report. Right now that section is 22" (which prints our on 2 pages.)but I'd like it to print out on about 3-4 pages so everything doesn't have to be squished together.

2.When I print the report it prints for all my records. I want it to print just the current record. Right now I have 3 test appraisals entered. I have a print button on the last page of the form and the form is in Edit mode so it only shows 1 record. When I press the print button the report prints all 3 appraisals.

Any help?

Rick

 

[WayneRyan]

Rick,

Access maxes out at 22", so don't know if there is any help there.

For the second part, the button should have a line of code:

Number:
DoCmd.OpenReport "YourReport",,,"[KeyField] = " & Me.KeyField

String:
DoCmd.OpenReport "YourReport",,,"[KeyField] = '" & Me.KeyField & "'"

Date:
DoCmd.OpenReport "YourReport",,,"[KeyField] = #" & Me.KeyField & "#"

Wayne

 

[rgreene]

In reference to #1
So how do you get a report to print out say 5 pages?

Thanks. I'll give the code a try