overlaying word documents in detail section of report

[Fran Tucker]

I have several Word Documents (OLE Objects) of various
lengths overlaying each other in the detail section of an
Access Report. I set the visible property to true for the
correct Word document to print in the vb code based on the
value of a variable.

I have the detail section properties Can Grow and Can
Shrink set to Yes. I have the detail section set to the
length of the longest document.

My problem is that there is space between the shorter Word
documents and the page footer(which has variable info in
it).

(I have also tried setting the detail height manually for
the Word document I need in vb - Me.Detail.Height =xxxx.
This is after I set the detail section to the length of
the shortest document in design view.)

Is there any way to butt the footer to the bottom of
whichever Word Document is visible?

Thanks!

 

[Guest]

-----Original Message-----
I have several Word Documents (OLE Objects) of various
lengths overlaying each other in the detail section of an
Access Report. I set the visible property to true for the
correct Word document to print in the vb code based on the
value of a variable.

I have the detail section properties Can Grow and Can
Shrink set to Yes. I have the detail section set to the
length of the longest document.

My problem is that there is space between the shorter Word
documents and the page footer(which has variable info in
it).

(I have also tried setting the detail height manually for
the Word document I need in vb - Me.Detail.Height =xxxx.
This is after I set the detail section to the length of
the shortest document in design view.)

Is there any way to butt the footer to the bottom of
whichever Word Document is visible?

Thanks!

.

Try creating a group (you may have to add a field to the
table) which will change at the appropriate point in the
report and print a group footer rather than a page
footer.

Kip