When One Line Is Not Enough

If you enter one- and two-line addresses in the same table, you probably have two fields, such as Address1 and Address2. However, if not all your addresses contain two lines, you can end up with blank lines between the Address1 and City fields in your reports and mailing labels. To avoid this problem, apply the Can Shrink property to the Address2 control. That way, Access omits the blank line when there's no entry in the Address2 field. Unfortunately, this technique won't work if your control has an attached label, since Access still prints the label text.

Access Index

Main Index