Printing Contracts-too long

  • Thread starter Thread starter SQL Brad
  • Start date Start date
S

SQL Brad

I have a front desk staff person who enters demographic data (lease info)
into a simple database. I want to print that demographic info such as name,
address, taxid, phone, apartment# being leased, lease terms, etc. THAT part
is sort of easy...however, the contract portion is too long to print on one
report. Any suggestions. I have the contract in word and so I've tried
copy/paste into a text box, and i've tried just pasting (where access creates
the text box) What I also want to do is have all the text on the page, and
then insert fields where I need them to print.

thanks in advance for suggs.
 
You can create multiple group headers/footers on a unique field to extend the
size of your detail section. For instance if LeaseID is the primary key in
the report's record source, create a new bottom level of sorting and grouping
on LeaseID and displays the header and footer section. Adjust the height of
these as necessary and move some of your detail controls into these new
sections.
 
I have taken Word documents that were used for customer quotes and pasted
them directly into the details section of a report and then taken the fields
from my record sources and overlayed them directly onto these. Worked great
and saved hours of forms design using something that already existed and was
in a format everyone was used to.
 
I think that works as long as the document is only one page (or less) in
length. I don't think it will work with anything longer than that.

If I am wrong, please educate me. I love discovering new things about Access.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top