473,322 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Eliminating Blank Line in Address Section of Report

MX1
Hi,

I have a report with Name1 and Name2 in the address section . Sometimes,
Name2 is not populated with data via the query that feeds the report.
Unfortunately, the blank line stays in the report. I've tried experimenting
with the Can Shrink property to no avail. Any tips on eliminating blank
lines the right way would be much appreciated.

thanks!
Nov 12 '05 #1
5 1823
On Fri, 09 Jan 2004 17:26:41 GMT, "MX1" <mx*@mx1.abc> wrote:
Hi,

I have a report with Name1 and Name2 in the address section . Sometimes,
Name2 is not populated with data via the query that feeds the report.
Unfortunately, the blank line stays in the report. I've tried experimenting
with the Can Shrink property to no avail. Any tips on eliminating blank
lines the right way would be much appreciated.

thanks!


CanShrink is the right way to do it, but you have to make sure of the
following.

1. There are no other controls overlapping that control's vertical extent.
2. The section and the control both need CanShring set to Yes.
Nov 12 '05 #2
Yes. The code goes in the "Control Source" property.
You also need to start with an "="
Fred
"MX1" <mx*@mx1.abc> wrote in message news:W_CLb.7263$na.5576@attbi_s04...
This is cool code. I'm not sure how to implement it though. Where does it go? In the property of the control. I tried the can grow/can shrink
suggested by Steve but is absolutely not working. I can't believe how
complex this is turning out to be. "Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:PC****************@newssvr25.news.prodigy.com ...
"MX1" <mx*@mx1.abc> wrote in message

news:lvBLb.7953$xy6.19472@attbi_s02...
Hi,

I have a report with Name1 and Name2 in the address section . Sometimes, Name2 is not populated with data via the query that feeds the report.
Unfortunately, the blank line stays in the report. I've tried

experimenting
with the Can Shrink property to no avail. Any tips on eliminating blank lines the right way would be much appreciated.

thanks!

I haven't ever played with the "can grow/shrink" properties. But, I've

used
a less elegant solution...

[name1]
iif(len([name2])=0,[address],[name2])
iif(len([name2])=0,[city] & ", " & [state] & " " & [zip],[address])
iif(len([name2])=0,"",[city] & ", " & [state] & " " & [zip])

Less elegant, but effective for me.
Fred Zuckerman
San Diego, CA, USA


Nov 12 '05 #3
MX1
This is working somewhat, but I seem to have 2 cases that I need to
accomodate for: Null Values and Values that had data but the data has since
been deleted so its now an empty string. I don't think the Len check is
working for this. Any thoughts?
"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:cL*****************@newssvr25.news.prodigy.co m...
Yes. The code goes in the "Control Source" property.
You also need to start with an "="
Fred
"MX1" <mx*@mx1.abc> wrote in message news:W_CLb.7263$na.5576@attbi_s04...
This is cool code. I'm not sure how to implement it though. Where does

it
go? In the property of the control. I tried the can grow/can shrink
suggested by Steve but is absolutely not working. I can't believe how
complex this is turning out to be.

"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:PC****************@newssvr25.news.prodigy.com ...
"MX1" <mx*@mx1.abc> wrote in message

news:lvBLb.7953$xy6.19472@attbi_s02...
> Hi,
>
> I have a report with Name1 and Name2 in the address section . Sometimes, > Name2 is not populated with data via the query that feeds the report. > Unfortunately, the blank line stays in the report. I've tried
experimenting
> with the Can Shrink property to no avail. Any tips on eliminating blank > lines the right way would be much appreciated.
>
> thanks!
>
I haven't ever played with the "can grow/shrink" properties. But, I've

used
a less elegant solution...

[name1]
iif(len([name2])=0,[address],[name2])
iif(len([name2])=0,[city] & ", " & [state] & " " & [zip],[address])
iif(len([name2])=0,"",[city] & ", " & [state] & " " & [zip])

Less elegant, but effective for me.
Fred Zuckerman
San Diego, CA, USA



Nov 12 '05 #4
The method I proposed was pedicated on [name2] would be the only blank
field.
I should have stated that assumption.

With more than one possibly blank field, then your iif() statements would
have to grow to accomodate ALL of the various combinations of possibly blank
fields. This would result in a large "Rube Goldberg" code block.

I think the solution proposed by Larry Linson in another post of your same
question will be a "cleaner" method.
His solution was to add the fields to vbCrLf and let Access take care of it.
(anything + null = null)

Good Luck
Fred

"MX1" <mx*@mx1.abc> wrote in message news:feHLb.9384$nt4.15963@attbi_s51...
This is working somewhat, but I seem to have 2 cases that I need to
accomodate for: Null Values and Values that had data but the data has since been deleted so its now an empty string. I don't think the Len check is
working for this. Any thoughts?
"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:cL*****************@newssvr25.news.prodigy.co m...
Yes. The code goes in the "Control Source" property.
You also need to start with an "="
Fred
"MX1" <mx*@mx1.abc> wrote in message news:W_CLb.7263$na.5576@attbi_s04... This is cool code. I'm not sure how to implement it though. Where does
it
go? In the property of the control. I tried the can grow/can shrink
suggested by Steve but is absolutely not working. I can't believe how
complex this is turning out to be.

"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:PC****************@newssvr25.news.prodigy.com ...
> "MX1" <mx*@mx1.abc> wrote in message
news:lvBLb.7953$xy6.19472@attbi_s02...
> > Hi,
> >
> > I have a report with Name1 and Name2 in the address section .

Sometimes,
> > Name2 is not populated with data via the query that feeds the report. > > Unfortunately, the blank line stays in the report. I've tried
> experimenting
> > with the Can Shrink property to no avail. Any tips on eliminating

blank
> > lines the right way would be much appreciated.
> >
> > thanks!
> >
>
>
> I haven't ever played with the "can grow/shrink" properties. But,

I've used
> a less elegant solution...
>
> [name1]
> iif(len([name2])=0,[address],[name2])
> iif(len([name2])=0,[city] & ", " & [state] & " " & [zip],[address])
> iif(len([name2])=0,"",[city] & ", " & [state] & " " & [zip])
>
> Less elegant, but effective for me.
> Fred Zuckerman
> San Diego, CA, USA
>
>



Nov 12 '05 #5
MX1
Thanks for your feedback Fred. :)

"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:FD****************@newssvr29.news.prodigy.com ...
The method I proposed was pedicated on [name2] would be the only blank
field.
I should have stated that assumption.

With more than one possibly blank field, then your iif() statements would
have to grow to accomodate ALL of the various combinations of possibly blank fields. This would result in a large "Rube Goldberg" code block.

I think the solution proposed by Larry Linson in another post of your same
question will be a "cleaner" method.
His solution was to add the fields to vbCrLf and let Access take care of it. (anything + null = null)

Good Luck
Fred

"MX1" <mx*@mx1.abc> wrote in message

news:feHLb.9384$nt4.15963@attbi_s51...
This is working somewhat, but I seem to have 2 cases that I need to
accomodate for: Null Values and Values that had data but the data has

since
been deleted so its now an empty string. I don't think the Len check is
working for this. Any thoughts?
"Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
news:cL*****************@newssvr25.news.prodigy.co m...
Yes. The code goes in the "Control Source" property.
You also need to start with an "="
Fred

>"MX1" <mx*@mx1.abc> wrote in message news:W_CLb.7263$na.5576@attbi_s04... > This is cool code. I'm not sure how to implement it though. Where does it
> go? In the property of the control. I tried the can grow/can shrink > suggested by Steve but is absolutely not working. I can't believe how > complex this is turning out to be.

> "Fred Zuckerman" <Zu********@sbcglobal.net> wrote in message
> news:PC****************@newssvr25.news.prodigy.com ...
> > "MX1" <mx*@mx1.abc> wrote in message
> news:lvBLb.7953$xy6.19472@attbi_s02...
> > > Hi,
> > >
> > > I have a report with Name1 and Name2 in the address section .
Sometimes,
> > > Name2 is not populated with data via the query that feeds the

report.
> > > Unfortunately, the blank line stays in the report. I've tried
> > experimenting
> > > with the Can Shrink property to no avail. Any tips on eliminating blank
> > > lines the right way would be much appreciated.
> > >
> > > thanks!
> > >
> >
> >
> > I haven't ever played with the "can grow/shrink" properties. But, I've > used
> > a less elegant solution...
> >
> > [name1]
> > iif(len([name2])=0,[address],[name2])
> > iif(len([name2])=0,[city] & ", " & [state] & " " & [zip],[address]) > > iif(len([name2])=0,"",[city] & ", " & [state] & " " & [zip])
> >
> > Less elegant, but effective for me.
> > Fred Zuckerman
> > San Diego, CA, USA
> >
> >
>
>



Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: L Mehl | last post by:
Different users of the app will want or not want to see report footer ( appears as a separate page). I can make the section invisible with a DLookup of a Y or N value from a 'parameters' table ...
5
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle...
6
by: MX1 | last post by:
Please help if you can. I have a form with an address field. There are 6 fields: Name1 Name2 Address1 Address2 CityStateZip Country
6
by: Melissa | last post by:
Does anyone have a generic procedure for adding blank lines to reports like Sales details, PO details and/or Orders details. The procedure would need to count the number of line items, determine...
2
by: New Guy | last post by:
I've been trying to look this up in Help but I've had no luck because I don't know what to call it. (That's not phrased very well but I think you get what I mean.) I have a report that is...
1
by: DAnne | last post by:
Hi, I have checked your archives but have not been able to find anything that works for my situation. I have a for loop that brings back a list of unique responses for each section in a report....
4
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
1
by: siomay87 | last post by:
please help i have a problem in the ms access reporting, my report have: page header, detail, page footer and report footer In listing "detail section", the number of line is depend on the data...
4
by: JHite | last post by:
I'm using AC2003. Sequence of events: a. Tool -> Relationships I show my tables & relationships and arrange them to fit landscape mode. b. File ->Print Relationships This generates a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.