Invoice - Report

T

Tony

Thanks Albert,

But when I fix the detail to a desired size, the records
that are returned are far away from each other. Not one
line after another (like several spaces between each
returned record). Does this make sense? I need to keep
each record one after another. Any suggestions?

Tony


Actually, if you fix part I, then Part II is done!

Simply set the detail size to what you want. Then in the
properties for the
detail section, simply turn off the can grow, and the can
shrink.

You have now fixed the length of the detail section.

If the detail gets full, you will get another page. And,
yes, you footing
will stay on the bottom of the page (in fact, it should be
anyway...regardless if the detail section can grow, or
shrink...the page
footer should stay on the bottom).


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
[email protected]
http://www.attcanada.net/~kallal.msn



Hello,

I've got a project where I have created an Invoice (Access
Report)for Products that are shipped. The report is a
simple query that can contain 1 to many records.

Question:

Part I
How can you program a report to have a fixed detail length
for 1 page with only 3 - 5 records. Then if the report
should contain for than 1 page will hold, I would like
this to continue onto the second page.

Part II
Is there a way to program the Report footer to remain on
the bottom of the page rather than following the detail.

Any suggestions would be appreciated!

Thanks.
 
Top