[AccessD] Removing blank line from a report

Just a jump in the deep end here - hope I don't cause a storm of
controversy.but if you are working with a large dataset, or a slow network,
those built in Access functions can really kill your response time.

Jeanine Scott
Sr. Systems Analyst
Spindustry Systems
515-669-2074
jscott at spindustry.com

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
information. Any unauthorized review, use, disclosure, or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message including any
attachments.

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Wortz, Charles
Sent: Tuesday, February 11, 2003 8: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/d73f194b/attachment-0002.html>