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 1837
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. Unfortunatel y, 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********@sbc global.net> wrote in message news:PC******** ********@newssv r25.news.prodig y.com... "MX1" <mx*@mx1.abc> wrote in message news:lvBLb.7953 $xy6.19472@attb i_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********@sbc global.net> wrote in message
news:cL******** *********@newss vr25.news.prodi gy.com... 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********@sbc global.net> wrote in message news:PC******** ********@newssv r25.news.prodig y.com... "MX1" <mx*@mx1.abc> wrote in message news:lvBLb.7953 $xy6.19472@attb i_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@attb i_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********@sbc global.net> wrote in message news:cL******** *********@newss vr25.news.prodi gy.com... 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********@sbc global.net> wrote in message news:PC******** ********@newssv r25.news.prodig y.com... > "MX1" <mx*@mx1.abc> wrote in message news:lvBLb.7953 $xy6.19472@attb i_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********@sbc global.net> wrote in message
news:FD******** ********@newssv r29.news.prodig y.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@attb i_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********@sbc global.net> wrote in message news:cL******** *********@newss vr25.news.prodi gy.com... 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********@sbc global.net> wrote in message > news:PC******** ********@newssv r25.news.prodig y.com... > > "MX1" <mx*@mx1.abc> wrote in message > news:lvBLb.7953 $xy6.19472@attb i_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
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Reports!rptValuationDetail.Section(acFooter).Visible = _
DLookup("", "sysparms", " = " & Chr(34) &
"printReportGrandTot" & Chr(34)) = "Y"
|
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 line page header,
three lines of detail (name address etc)and a footer.
On previewing or printing the report it inserts a blank three line
detail section before the first record. Every other page is fine
except this first page. Not a big deal but it...
|
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 the remaining page to fill and
print blank lines with the same number of fields as the line items. In
addition, if there were a long list of line items that carried over to a
second and possibly more pages, to print blank lines at the last page. The...
|
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 working fine except for this format issue that
I can't figure out how to fix.
In my detail section, I have two lines for each item in my report.
The first line's fields always have data. Sometimes, the fields in
the second line are all NULL and the...
| |
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. These responses are responses to each question in a particular section.
This is working fine. However the output prints many blank lines. I have determined that these lines are are actually places where the question had the same response as a...
|
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 hundreds
(perhaps even an infinite loop...I have to break the system to stop the
report generating) of pages.
While I'm not 100% I think this may have something to do with the detail
|
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 source
I mean long or short in detail section is vary.
The problem is, when the detail is more than 25 line
it will give blank area below the 25th line in page 1, and page 2 continue with report footer.
This blank area in page is cause by...
|
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 report in portrait mode with name/date etc. in report header section, an empty page header section, and diagram of relationships in detail section.
c. I go into setup, change to landscape orientation and adjust margins so my "print" is not too...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |