What to Do with Pesky Blank Lines
If you have three address lines and an address needs only two, you don’t want an unsightly gap to show up on the report where the address line is supposed to be. Although Access has made provisions for this common problem, it turns out to be a classic good news/bad news situation. The good news is that Access has a property that handles blank lines in reports. The CanShrink property can move the control underneath the blank control up so that the blank line is suppressed. The bad news is that this property doesn’t work if a label is attached or an image is beside the control.
CanShrink Solution to Blank Lines
However, if you have no labels or images in the part of the report that needs the line suppression, ...
Get Access 2002 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
