[AccessD] Removing blank line from a report

Mark Boyd MarkBoyd at McBeeAssociates.com
Tue Feb 11 08:32:01 CST 2003


I have a report that is formatted like a business letter.

In the address section (which is in the page header), I have the
following 4 fields:

[BillingName]

[Addr1]

[Addr2]

[CityStZip]

 

How can I force the [CityStZip] up a line when [Addr2] is blank?

Most of the addresses look like this:

 

John Smith

123 Main St.

 

City, St  12345

 

 

I tried setting the CanShrink property of [Addr2] to 'Yes', but this
doesn't work.

Any ideas?

 

 

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030211/cba53d44/attachment-0001.html>


More information about the AccessD mailing list