[AccessD] Removing blank line from a report

Susan -

What version of Access are you using?

This project uses Access2000.

 

Mark

 

-----Original Message-----
From: Klos, Susan [mailto:Susan.Klos at fldoe.org] 
Sent: Tuesday, February 11, 2003 10:57 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Removing blank line from a report

 

I have a report with the same type of controls in the page header.  I
get a CanShrink proterty for the control.

	-----Original Message-----
	From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com]
	Sent: Tuesday, February 11, 2003 10:30 AM
	To: accessd at databaseadvisors.com
	Subject: RE: [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/b2dc2afd/attachment-0002.html>