If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How conditionally skip stuff on a report?
Good morning,
I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#2
|
|||
|
|||
How conditionally skip stuff on a report?
When you say "skip", do you mean "don't show ANY of the fields in a record
that has nothing in the [Comments] field? If so, use a query! Exclude rows with "blanks" (now the tough part ... "blank" could mean Null, or zero-length string, or spaces ... they all look blank to me!). Your query needs to exclude any of those possibilities. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#3
|
|||
|
|||
How conditionally skip stuff on a report?
Hello Ray,
Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#4
|
|||
|
|||
How conditionally skip stuff on a report?
As asked, the original poster wished to "skip that record", not (merely) the
control/blank... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message m... Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#6
|
|||
|
|||
How conditionally skip stuff on a report?
Steve
Here's a direct quote from the OP - "How do I get the report to skip that record. " Yes, the OP also mention the blank..., but asked a direct question about skipping a record. My initial response asked the OP for clarification, whether "skip" meant the entire record or just the field. Regards Jeff "Steve" wrote in message m... Read a little closer! He doesn't want to see a blank line when there is no comment. This is the same as is typically done when there are Address1 and Address2 fields in an address and there is no Address2. Steve "Jeff Boyce" wrote in message ... As asked, the original poster wished to "skip that record", not (merely) the control/blank... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message m... Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#7
|
|||
|
|||
How conditionally skip stuff on a report?
The OP said " When the report prints, it prints a blank line if the comment
is blank (obviously). How do I get the report to skip that record." A record would not just include a comment field. The record would include at least one or more fields. Just because the comment field is blank does not mean the report should not display other info in the record. Like many posts to the newsgroups, terms are misused. I interpret the OP's question to mean he does not want to see the blank line left by the comment field when there is no comment. Just like not wanting to see a blank line when there is no Address2. I'm not saying you are wrong! Steve "Jeff Boyce" wrote in message ... Steve Here's a direct quote from the OP - "How do I get the report to skip that record. " Yes, the OP also mention the blank..., but asked a direct question about skipping a record. My initial response asked the OP for clarification, whether "skip" meant the entire record or just the field. Regards Jeff "Steve" wrote in message m... Read a little closer! He doesn't want to see a blank line when there is no comment. This is the same as is typically done when there are Address1 and Address2 fields in an address and there is no Address2. Steve "Jeff Boyce" wrote in message ... As asked, the original poster wished to "skip that record", not (merely) the control/blank... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message m... Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#8
|
|||
|
|||
How conditionally skip stuff on a report?
We're in agreement, then ...
We need to know how the OP is defining his terms to offer an suitable approach. Regards Jeff B. "Steve" wrote in message m... The OP said " When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record." A record would not just include a comment field. The record would include at least one or more fields. Just because the comment field is blank does not mean the report should not display other info in the record. Like many posts to the newsgroups, terms are misused. I interpret the OP's question to mean he does not want to see the blank line left by the comment field when there is no comment. Just like not wanting to see a blank line when there is no Address2. I'm not saying you are wrong! Steve "Jeff Boyce" wrote in message ... Steve Here's a direct quote from the OP - "How do I get the report to skip that record. " Yes, the OP also mention the blank..., but asked a direct question about skipping a record. My initial response asked the OP for clarification, whether "skip" meant the entire record or just the field. Regards Jeff "Steve" wrote in message m... Read a little closer! He doesn't want to see a blank line when there is no comment. This is the same as is typically done when there are Address1 and Address2 fields in an address and there is no Address2. Steve "Jeff Boyce" wrote in message ... As asked, the original poster wished to "skip that record", not (merely) the control/blank... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message m... Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#9
|
|||
|
|||
How conditionally skip stuff on a report?
Yes, we are in agreement on defining terms.
The issue is your second post in this thread. I don't appreciate you criticizing my suggested solution. You could have let well enough alone with your first response without criticizing my response. We had different solutions and the OP could have chosen the one he wanted or came back and asked another question. You attacked my post which violates the Rules of Conduct for an MVP. I would appreciate you not doing that again. Regards, Steve "Jeff Boyce" wrote in message ... We're in agreement, then ... We need to know how the OP is defining his terms to offer an suitable approach. Regards Jeff B. "Steve" wrote in message m... The OP said " When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record." A record would not just include a comment field. The record would include at least one or more fields. Just because the comment field is blank does not mean the report should not display other info in the record. Like many posts to the newsgroups, terms are misused. I interpret the OP's question to mean he does not want to see the blank line left by the comment field when there is no comment. Just like not wanting to see a blank line when there is no Address2. I'm not saying you are wrong! Steve "Jeff Boyce" wrote in message ... Steve Here's a direct quote from the OP - "How do I get the report to skip that record. " Yes, the OP also mention the blank..., but asked a direct question about skipping a record. My initial response asked the OP for clarification, whether "skip" meant the entire record or just the field. Regards Jeff "Steve" wrote in message m... Read a little closer! He doesn't want to see a blank line when there is no comment. This is the same as is typically done when there are Address1 and Address2 fields in an address and there is no Address2. Steve "Jeff Boyce" wrote in message ... As asked, the original poster wished to "skip that record", not (merely) the control/blank... Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Steve" wrote in message m... Hello Ray, Have you tried setting the Comments field in your report Can Shrink property to Yes? Setting it to Yes will cause the textbox's height to shrink to 0 and thus not give you the blank line. Steve ray anselmi wrote in message ... Good morning, I saw the article "How conditionally display stuff on a report?", however I have a slight twist. I have a field "comments" that is occasionally blank. When the report prints, it prints a blank line if the comment is blank (obviously). How do I get the report to skip that record. I tried the IIF statement with no luck. Thanks!! EggHeadCafe - Software Developer Portal of Choice How to detect and Automatically install MSXML http://www.eggheadcafe.com/tutorials...d-automat.aspx |
#10
|
|||
|
|||
How conditionally skip stuff on a report?
"Steve" wrote in message
m... You attacked my post which violates the Rules of Conduct for an MVP. He commented on your lack of profesionalism. I would appreciate you not doing that again. Steve and we would appreciate you following the rules and stop pimping your limited skills. John... Visio MVP |
Thread Tools | |
Display Modes | |
|
|