[AccessD] Removing blank line from a report

Assuming that each field is in a separate TextBox, all you need to do is set
the Report section and TextBox CanShrink property to True.  Access will take
care of the rest for you!
 

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
Sent: Tuesday, February 11, 2003 8:25 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Removing blank line from a report



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/5d52c9cc/attachment-0002.html>