T
tinab
I have a designed a database for a contractor. I have a form to enter
quote information to specify the scope of work. I have a quotes table
with the fields: estimateID, quoteID, Alternative A, Price A,
ALternative B, Price B and Alternative C, Price C. On the form I have
a subform for each Alternative (3 tables Quote details 1, 2 and 3).
These subforms contain two fields ClauseID and Clause Name. I have a
quote report that contains the 3 subforms information in the
estimateID header. The rest of the report is in the details sections
and consists of data that is used in every quote and does not change
(ie. number 2-8 with information about payment terms, insurance,
warrantees, etc. and I used 3 subreports for this info.) The last
paragraph is also the same and is about 5 sentences and then has
"Yours truly, Manager" with a line for the signature. The problem is
sometimes, depending on the information in the subforms (there could
be 3 clauses or 20 in one or more of the subforms) this last paragraph
gets split up and the signature line will be on a page by itself. I
have the quote details subforms and text boxes set to .007 height and
to grow and shrink. I put the following code in the text boxes
containing the price:
=IIf(IsNull([PriceA]),Null,"Price: " &
Format([PriceA],"$#,##0.00")) so they will not leave space if there is
no information in the subform. All the subreports are set to grow and
shrink. I want the report to grow and shrink depending on the
information and not leave unnecessary space but always keep the last
paragraph together. I have tried a lot of different scenarios with
the keep together option but I am stumped, please help.
quote information to specify the scope of work. I have a quotes table
with the fields: estimateID, quoteID, Alternative A, Price A,
ALternative B, Price B and Alternative C, Price C. On the form I have
a subform for each Alternative (3 tables Quote details 1, 2 and 3).
These subforms contain two fields ClauseID and Clause Name. I have a
quote report that contains the 3 subforms information in the
estimateID header. The rest of the report is in the details sections
and consists of data that is used in every quote and does not change
(ie. number 2-8 with information about payment terms, insurance,
warrantees, etc. and I used 3 subreports for this info.) The last
paragraph is also the same and is about 5 sentences and then has
"Yours truly, Manager" with a line for the signature. The problem is
sometimes, depending on the information in the subforms (there could
be 3 clauses or 20 in one or more of the subforms) this last paragraph
gets split up and the signature line will be on a page by itself. I
have the quote details subforms and text boxes set to .007 height and
to grow and shrink. I put the following code in the text boxes
containing the price:
=IIf(IsNull([PriceA]),Null,"Price: " &
Format([PriceA],"$#,##0.00")) so they will not leave space if there is
no information in the subform. All the subreports are set to grow and
shrink. I want the report to grow and shrink depending on the
information and not leave unnecessary space but always keep the last
paragraph together. I have tried a lot of different scenarios with
the keep together option but I am stumped, please help.