"Floating" height of a report

[greaseman]

I am using Access 2003 and Word 2003. I've got some Word documents that my client has been using for a Mail Merge, but in Office 2003, Mr. Gates seems to have drastically changed how Mail Merge workss (or doesn't??).

Because of our mailmerge problems, I am redesigning my client's letters in Access as reports. I have one letter that can have several optional data fields, as follows:

"You need the following:

Your address (this is first optional field)
Your telephone (this is second optional field)
Your employee number (this is third optional field)

and so on....."

My question is: in an Access report like this, if I don't have all of the optional fields, how would I go about shrinking the letter form so that I avoid the appearance of a lot of space?

Any suggestions are greatly appreciated, and thank you!

 

[Rich]

Use the CanShrink options for various areas of the Report

 

[greaseman]

Thanks for your reply, Rich. I had already tried the Can Shrink option, and it appears to not have worked. My report has multiple text boxes in the detail section... one text box each for each of its exception items. The format is somewhat like:

HEADER
_________________________________________________

DETAIL (can shrink)

txtNoInsurance (canshrink)
txtNoTitle (canshrink)
txtNoBorrower (can shrink)
txtNeedMore (can shrink)

_______________________________________
FOOTER

In other words, each exception in the detail portion either will or will not have data. And each field is on its own line, if it has data. What I want is that if the fields have no data, to "shrink" the size of the detail report. Also, the fields in question are boolean data fields. Does that cause issues?

Thanks again!

 

[greaseman]

I got it working, but did not use the Can Shrink property of the text box. I used information I gleaned from a Microsoft Knowledge Base article, QD95390.

Works like a charm now.