[AccessD] Removing blank line from a report

Stuart Sanders stuart at pacific.net.hk
Tue Feb 11 10:43:00 CST 2003


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/75c9bfcf/attachment-0002.html>


More information about the AccessD mailing list