[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/2cfeff70/attachment-0002.html>