[AccessD] Removing blank line from a report

Charles -

That's perfect.

Thanks again.

 

Mark

 

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Tuesday, February 11, 2003 9:45 AM
To: accessd at databaseadvisors.com
Subject: RE: [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/5edbf865/attachment-0002.html>