I am having a problem with MS Access 2003 where blank lines are showing in my report, for example an address line 2. There is only one control on the line, it has it's property 'can shrink' to 'yes'. I even put in visual basic function which I got from a website to eliminate these unwanted lines, but that didn't work.   Can you help?

---

Answer from Richard Rost:

You have to set the CAN SHRINK property for both the control AND the section it's in (usually the Detail section) to YES. Then if the field is blank and there are no other controls to the left or right of it, it will disappear.