[AccessD] Removing blank line from a report

Mark Boyd MarkBoyd at McBeeAssociates.com
Tue Feb 11 11:05:01 CST 2003


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/8d197c42/attachment-0002.html>


More information about the AccessD mailing list