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>