Clare

I've not noticed the problem you mention touching controls. Have you
also set the "Can Shrink" for the section, as a whole?

--
Good luck

Jeff Boyce
Access MVP

"Clare" wrote in message
...
I am creating a mailing report and would like to ignore address fields if
they are blank. I have tried the 'can shrink' which does work if the text
boxes aren't touching each other, but the gap above and below the shrunken
text box are still there so the address still has a space in the middle.
If
the text boxes are touching each other then the can shrink doesn't seem to
work.

I have tried concatenating the string and using & Chr(13) & Chr(10) &
between the fields, but that obviously still leaves a line space.

In the control source expression builder I've started with this but don't
know what to put next.

IIf ( IsNull ( [Address] ) , «truepart», «falsepart»)

Any help would be greatly appreciated