Stuart Sanders
stuart at pacific.net.hk
Tue Feb 11 09:27:41 CST 2003
John, Set the "Can Shrink" property for the field to yes Stuart -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd Sent: Tuesday, 11 February, 2003 10:25 PM 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/6b3a3a2e/attachment-0002.html>