Print a whole report in one page

[Guest]

I have written a program to help the user input information an a patient chart. I want the report to print on one sheet of paper. I have designed the report to do this with all the margins ie top, bottomn, left and right at 0.2. This works for a while and then all of a suddenly each page has a second page that is blank. I want the whole thing in one page I do not care if it gets truncated in the process but it must fit in one page. Is there a way in the properties to force this to take place?

While were are at the subject is there a way to jus print only the record that is open at the time instead of all the records?

You guys are awsome I will remember you if I ever become big with this thing.

 

[Larry Linson]

Generally, the printing of a blank page means that there is some blank space
that has been "pushed" beyond the end of the page, or that the width of the
page plus margins is greater than the width of the paper. From your
description, I'd guess the former is happening. Look at anything that can
vary... like a control that has the CanGrow property set to Yes, or a
Section that has CanGrow set to Yes... I believe that is the default
setting. You may be able to correct the problem just by re-setting that
property to a value of No in every case.

There are at least two ways to limit a report to a single record:

-- the simplest, but least efficient, is to create in VBA code a
WhereCondition argument for the DoCmd.OpenReport that causes the report to
execute... use the unique id of the record that is currently displayed.
-- slightly more complicated, but more efficient, is to create an SQL
statement with a WHERE clause using that same ID and, in the Open event of
the Report, replace the Report's RecordSource with the SQL statement you've
created.

Good luck with your project.

Larry Linson
Microsoft Access MVP

I have written a program to help the user input information an a patient

chart. I want the report to print on one sheet of paper. I have designed the
report to do this with all the margins ie top, bottomn, left and right at
0.2. This works for a while and then all of a suddenly each page has a
second page that is blank. I want the whole thing in one page I do not care
if it gets truncated in the process but it must fit in one page. Is there a
way in the properties to force this to take place?

While were are at the subject is there a way to jus print only the record

that is open at the time instead of all the records?

You guys are awsome I will remember you if I ever become big with this

thing.

 

[Jim/Chris]

There is a bug in Access 2000 which caused the loss of page
settings. Installing the latest service patches from
Microsoft will fix this. The workaround until you can
install those patches it to go to Tools/Options general tab
and uncheck the "Track Name AutoCorrect info" box

Jim

-----Original Message-----
I have written a program to help the user input

information an a patient chart. I want the report to print
on one sheet of paper. I have designed the report to do
this with all the margins ie top, bottomn, left and right
at 0.2. This works for a while and then all of a suddenly
each page has a second page that is blank. I want the whole
thing in one page I do not care if it gets truncated in the
process but it must fit in one page. Is there a way in the
properties to force this to take place?

While were are at the subject is there a way to jus print

only the record that is open at the time instead of all the
records?