Hello,

I'd like to print out a master detail report where many of the
detail attributes are optional. However, I don't want to print out
blanks where ever a field is empty. Instead I want the printed data
to be packed together.

For example, say you have a contact database and for each person you
can have several phone numbers including cell, fax, pager, home
and work, etc. The same for email addresses. It would be nice to
be able to print the report where records for people with only one
phone number (and I you don't know which) takes up only one row in
the report rather than several rows of "conditionally formatted"
blanks.

Thanks.

Set the Can Shrink property of the report's text boxes. Then they "shrink" to nothing if there is no data in them.

Hope this helps,


Clive Astley