[AccessD] Removing blank line from a report

But not for the section.
 
Charlotte Foust

	-----Original Message-----
	From: Klos, Susan [mailto:Susan.Klos at fldoe.org] 
	Sent: Tuesday, February 11, 2003 11:31 AM
	To: 'accessd at databaseadvisors.com'
	Subject: RE: [AccessD] Removing blank line from a report
	
	
	But you can set CanGrow and CanShrink for textboxes in Page
headers.

		-----Original Message-----
		From: Charlotte Foust
[mailto:cfoust at infostatsystems.com]
		Sent: Tuesday, February 11, 2003 2:19 PM
		To: accessd at databaseadvisors.com
		Subject: RE: [AccessD] Removing blank line from a report
		
		
		You can't set CanGrow and CanShrink for Page headers,
only for the Report Header and for group headers.
		 
		Charlotte Foust

			-----Original Message-----
			From: Mark Boyd
[mailto:MarkBoyd at mcbeeassociates.com] 
			Sent: Tuesday, February 11, 2003 9:04 AM
			To: accessd at databaseadvisors.com
			Subject: RE: [AccessD] Removing blank line from
a report
			
			

			I guess I misunderstood.

			I can set the field properties, but not the page
header properties.

			Doesn't the section's CanGrow and CanShrink
properties need to be set in order to affect the fields' CanGrow and
CanShrink properties?

			 

			Mark

			 

			-----Original Message-----
			From: Stuart Sanders
[mailto:stuart at pacific.net.hk] 
			Sent: Tuesday, February 11, 2003 11:42 AM
			To: accessd at databaseadvisors.com
			Subject: RE: [AccessD] Removing blank line from
a report

			 

			The property exists in my copy of Access 2000
for fields in the Page Header.

			 

			Stuart

				-----Original Message-----
				From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd
				Sent: Wednesday, 12 February, 2003 12:06
AM
				To: accessd at databaseadvisors.com
				Subject: RE: [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/a22a5b93/attachment-0002.html>