I would think that what you wnat is the CanShrink property.
I'm guessing that you have built your query to exclude the records you don't
want in your report, you are just running into trouble when there are blank
fields (like Address2)?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.