[AccessD] Removing blank line from a report - D'OH!

Brett Barabash BBarabash at TappeConstruction.com
Tue Feb 11 09:36:00 CST 2003


Sorry about that Mark.  I reread your message and saw that you already tried
the CanShrink method.  Concatenating multiple fields together probably makes
the most sense then.
 
BTW, Jeanine was right.  IIf can slow down your performance in many cases.
I would suggest using a single TextBox for the entire address with the
following ControlSource:
 
=[BillingName] & Chr$(13) & Chr$(10) & [Addr1] & Chr$(13) & Chr$(10) &
([Addr2]+Chr$(13)+Chr$(10)) & [CityStZip]
 
When you use a + sign with Null arguments, the result is always null.  We
can then concatenate it to the rest of the string.

-----Original Message-----
From: Brett Barabash [mailto:BBarabash at tappeconstruction.com]
Sent: Tuesday, February 11, 2003 9:21 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [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/7297f2b1/attachment-0001.html>


More information about the AccessD mailing list