Skip to Main Content
Access 2002 Programming by Example
book

Access 2002 Programming by Example

by Bob Villareal
January 2002
Beginner content levelBeginner
576 pages
13h 23m
English
Que
Content preview from Access 2002 Programming by Example

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, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

Julitta Korol
Microsoft® Access® 2010 Programmer's Reference

Microsoft® Access® 2010 Programmer's Reference

Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Jerry Dennison

Publisher Resources

ISBN: 0789725940Purchase book