January 2002
Beginner
576 pages
13h 23m
English
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.
However, if you have no labels or images in the part of the report that needs the line suppression, ...