[AccessD] Removing blank line from a report

Mark,
 
Set the datasource for the last two fields as such:
[txtAddr2] = IIF(IsNull([Addr2], [CityStZip],[Addr2])
[txtCity] = IIF(IsNull([Addr2],"",[CityStZip])
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
(SELECT * FROM users WHERE clue > 0) 

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
Sent: Tuesday 2003 Feb 11 08:25
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/65a54088/attachment-0002.html>