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! 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.
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
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
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 > >
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 > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
...
|
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...
|
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
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
| |