[AccessD] Removing blank line from a report

Brett -

The problem with that is the fields are in the page header ... no
CanShrink property there.

 

Thanks,

Mark

 

-----Original Message-----
From: Brett Barabash [mailto:BBarabash at tappeconstruction.com] 
Sent: Tuesday, February 11, 2003 10: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/ca2cf99f/attachment-0002.html>