Mark Boyd
MarkBoyd at McBeeAssociates.com
Tue Feb 11 09:26:28 CST 2003
Bob - Thanks for the reply. This looks like a great idea, but I think Charles' response works better for my situation. Actually, the [CityStZip] field on the report concatenates 3 individual fields .. I should have been more descriptive. Thanks again, Mark -----Original Message----- From: Bob Gajewski [mailto:bob at renaissancesiding.com] Sent: Tuesday, February 11, 2003 9:53 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Removing blank line from a report Mark There's a couple of different ways to do this. My preference is: 1) Use unbound text boxes txtName txtAddr1 txtAddr2 txtAddr3 2) Set them all to CanShrink=Yes 3) Set their values in code/source txtName = [BillingName] txtAddr1 = [Addr1] If [Addr2]="" Then txtAddr2 = [CityStZip] txtAddr3 = "" Else txtAddr2 = [Addr2] txtAddr3 = [CityStZip] End If Just put the applicable section for each in the control source. Do you really have a single field for the city, state code and zip code? Regards, Bob Gajewski On Tuesday, February 11, 2003 09:25 AM, Mark Boyd [SMTP:MarkBoyd at mcbeeassociates.com] wrote: > 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 > > > > << File: ATT00006.htm >> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com