• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Taking Charge of Reports > What to Do with Pesky Blank Lines

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, use the CanShrink property. When you set the CanShrink property of a control on the report to Yes, the line is suppressed when the control is blank. When using the CanShrink property, remember the following:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint