[AccessD] Removing blank line from a report

A2K  Here is what I have for data source for CSZ:=Trim([City] & ", " &
[state] & "  " & [zip] & IIf(IsNull([plus4]),"","-" & [plus4]))
The SecondAddress text box is set to CanShrink.  (In fact all of them are
set that way)  It works everytime.

-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com]
Sent: Tuesday, February 11, 2003 11: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/a3093364/attachment-0002.html>