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

Hi:
There are 2 ways ti deak with your second question.
The easy way is this:
Create a query based on the table.
Lets assume that each record has a unique key and that the key is one
the form.
Lets assume that form is named MyForm and the key field is named
MyKey.
In the query goto the criteria line for the key field and type:
forms!Myform!MyKey (case doesn't matter)
Copy your report and base the new one on the query.
Have the button execute the new report. The form must be open for
this to work.

As to your first question, I'd have to see it.
If you wish zip the db and e_mail it and I'll take a look.

Good luck
Ira Solomon

On Thu, 22 Sep 2005 12:30:20 -0400, "firecop1" <jb5540 (AT) msn (DOT) com> wrote: