|
Subject:
|
Easy One
|
|
Posted By:
|
ru1
|
Post Date:
|
9/15/2006 11:15:51 AM
|
How can I stop a line from printing in an MS Access report if there is no data in it? For example, the second line of an Address in a Lable report? But, this is not in a Label report, it is a regular report?
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
9/15/2006 2:05:28 PM
|
Set the control's Can Shrink property to Yes
What do I win?
mmcdonal
|
|
Reply By:
|
Loralee
|
Reply Date:
|
9/15/2006 10:36:27 PM
|
Chuck,
Another alternative. If the field name is [Address2]:
1) create an unbound text box where you want [address2] to print.
2) set it's value to " = iif([address2] <> "", [address2], "")
|
