A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How conditionally skip stuff on a report?



 
 
Thread Tools Display Modes
  #21  
Old October 18th, 2009, 07:49 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default How conditionally skip stuff on a report?

You track all my posts. You have seen the URL posted more than once.

Regards,

Steve


"Gina Whipp" wrote in message
...
Steve,

I'd like to know where these MVP Rules of Conduct are, as my awareness is
of the Rules of Conduct that govern these newsgroups... which applies to
everyone, you know the ones you ignore, not just MVP's. Of course, I
probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
Jeff,

As an MVP you have the responsibility to not only strive to behave in
concordance with the MVP Rules of Conduct but to also admonish other MVPs
that breach the MVP Rules of Conduct. Do you condone the conduct of Visio
John?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread" that
you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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






















  #22  
Old October 18th, 2009, 08:29 PM posted to microsoft.public.access.reports
Arno R[_2_]
external usenet poster
 
Posts: 35
Default How conditionally skip stuff on a report?


"Steve" schreef in bericht
...
Just like you can't drop it; there was no need to respond to my post as you did other
than to get your dig in me!

Regards,

Steve


Now who's clinically obsessive here... ??
haha hilarious! You really make my day...

Regards,
Arno R

BTW: You did take your pills ?? I am afraid not ...


  #23  
Old October 18th, 2009, 08:42 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default How conditionally skip stuff on a report?

Yes Sir! We all bow to your command...

Pitiable...

Jeff

"Steve" wrote in message
m...
Can't you read? I said in my post " Now let's drop it - it's done and
over!"

You just want to continue to drag this on to invite Visio John to reply
again. Maybe you will get Arno R or Leith Wilby to reply too. Then will
you be happy?

Regards,

Steve

"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in message
...
It's over when and because you say it is?!

How did my response "implicitly criticize" your proposed solution? If
you don't provide an explicit description, how do you expect me to be
able to change my behavior?

I accept responsibility for my posts and behavior. I don't have the
power to "cause ... John" to post.

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...
The fact that you posted it as a response to my post implicitly
criticizing my proposed solution. All you did was to cause Visio John to
interject a defamatory comment.

Now let's drop it - it's done and over!

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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
























  #24  
Old October 18th, 2009, 09:04 PM posted to microsoft.public.access.reports
Gina Whipp
external usenet poster
 
Posts: 3,500
Default How conditionally skip stuff on a report?

That would be for EVERYONE, not for just MVP's. So I guess that explains
why you consistently ignore them, you don't think they apply to you?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You track all my posts. You have seen the URL posted more than once.

Regards,

Steve


"Gina Whipp" wrote in message
...
Steve,

I'd like to know where these MVP Rules of Conduct are, as my awareness is
of the Rules of Conduct that govern these newsgroups... which applies to
everyone, you know the ones you ignore, not just MVP's. Of course, I
probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
Jeff,

As an MVP you have the responsibility to not only strive to behave in
concordance with the MVP Rules of Conduct but to also admonish other
MVPs that breach the MVP Rules of Conduct. Do you condone the conduct of
Visio John?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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
























  #25  
Old October 18th, 2009, 09:34 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default How conditionally skip stuff on a report?

Once again you earn the "B" word!!!!!!!!!!!!!!!

You track all my posts. You have seen the URL for Rules Of Conduct for MVPs
posted more than once. Of course, don't ask Jeff Boyce; he doesn't know what
they are or chooses not to follow them.

Regards,

Steve


"Gina Whipp" wrote in message
...
That would be for EVERYONE, not for just MVP's. So I guess that explains
why you consistently ignore them, you don't think they apply to you?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You track all my posts. You have seen the URL posted more than once.

Regards,

Steve


"Gina Whipp" wrote in message
...
Steve,

I'd like to know where these MVP Rules of Conduct are, as my awareness
is of the Rules of Conduct that govern these newsgroups... which
applies to everyone, you know the ones you ignore, not just MVP's. Of
course, I probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
Jeff,

As an MVP you have the responsibility to not only strive to behave in
concordance with the MVP Rules of Conduct but to also admonish other
MVPs that breach the MVP Rules of Conduct. Do you condone the conduct
of Visio John?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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


























  #26  
Old October 18th, 2009, 09:36 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default How conditionally skip stuff on a report?

And one more thing, aren't you going to answer my question in my other post?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in message
...
... and one more thing. Even if my response "implicitly criticized" your
proposed solution, how do you bridge the obvious gap to considering that
an attack?

Are you suggesting that anyone who disagrees with you or criticizes
something you propose is attacking you?

--

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...
The fact that you posted it as a response to my post implicitly
criticizing my proposed solution. All you did was to cause Visio John to
interject a defamatory comment.

Now let's drop it - it's done and over!

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread" that
you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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






















  #27  
Old October 19th, 2009, 12:02 AM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default How conditionally skip stuff on a report?

I can't. You told me to drop it...

Jeff

"Steve" wrote in message
m...
And one more thing, aren't you going to answer my question in my other
post?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in message
...
... and one more thing. Even if my response "implicitly criticized" your
proposed solution, how do you bridge the obvious gap to considering that
an attack?

Are you suggesting that anyone who disagrees with you or criticizes
something you propose is attacking you?

--

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...
The fact that you posted it as a response to my post implicitly
criticizing my proposed solution. All you did was to cause Visio John to
interject a defamatory comment.

Now let's drop it - it's done and over!

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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
























  #28  
Old October 19th, 2009, 12:46 AM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default How conditionally skip stuff on a report?

OK, you're as slippery as a lizard.

As an MVP you still have the responsibility to not only strive to behave in
concordance with the MVP Rules of Conduct but to also admonish other MVPs
that breach the MVP Rules of Conduct. The next time Visio John posts his
non-professional defamatory and libelous statement against me in one of the
MS public newsgroup, let's see if you have the integrity to admonish him.

Regards,

Steve

"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in message
...
I can't. You told me to drop it...

Jeff

"Steve" wrote in message
m...
And one more thing, aren't you going to answer my question in my other
post?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
... and one more thing. Even if my response "implicitly criticized"
your proposed solution, how do you bridge the obvious gap to considering
that an attack?

Are you suggesting that anyone who disagrees with you or criticizes
something you propose is attacking you?

--

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...
The fact that you posted it as a response to my post implicitly
criticizing my proposed solution. All you did was to cause Visio John
to interject a defamatory comment.

Now let's drop it - it's done and over!

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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


























  #29  
Old October 19th, 2009, 08:50 AM posted to microsoft.public.access.reports
Mark[_23_]
external usenet poster
 
Posts: 8
Default How conditionally skip stuff on a report?

don't suppose any of you guys/gals have time to look at my post "Report
Footer, multi-column rpt", would you?
Thanks,
Mark

"Steve" wrote in message
m...
Once again you earn the "B" word!!!!!!!!!!!!!!!

You track all my posts. You have seen the URL for Rules Of Conduct for

MVPs
posted more than once. Of course, don't ask Jeff Boyce; he doesn't know

what
they are or chooses not to follow them.

Regards,

Steve


"Gina Whipp" wrote in message
...
That would be for EVERYONE, not for just MVP's. So I guess that

explains
why you consistently ignore them, you don't think they apply to you?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -

Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You track all my posts. You have seen the URL posted more than once.

Regards,

Steve


"Gina Whipp" wrote in message
...
Steve,

I'd like to know where these MVP Rules of Conduct are, as my awareness
is of the Rules of Conduct that govern these newsgroups... which
applies to everyone, you know the ones you ignore, not just MVP's. Of
course, I probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
Jeff,

As an MVP you have the responsibility to not only strive to behave in
concordance with the MVP Rules of Conduct but to also admonish other
MVPs that breach the MVP Rules of Conduct. Do you condone the conduct
of Visio John?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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




























  #30  
Old October 19th, 2009, 04:02 PM posted to microsoft.public.access.reports
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default How conditionally skip stuff on a report?

Hi Mark,

I just responded!!

Steve


"Mark" wrote in message
...
don't suppose any of you guys/gals have time to look at my post "Report
Footer, multi-column rpt", would you?
Thanks,
Mark

"Steve" wrote in message
m...
Once again you earn the "B" word!!!!!!!!!!!!!!!

You track all my posts. You have seen the URL for Rules Of Conduct for

MVPs
posted more than once. Of course, don't ask Jeff Boyce; he doesn't know

what
they are or chooses not to follow them.

Regards,

Steve


"Gina Whipp" wrote in message
...
That would be for EVERYONE, not for just MVP's. So I guess that

explains
why you consistently ignore them, you don't think they apply to you?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -

Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
You track all my posts. You have seen the URL posted more than once.

Regards,

Steve


"Gina Whipp" wrote in message
...
Steve,

I'd like to know where these MVP Rules of Conduct are, as my
awareness
is of the Rules of Conduct that govern these newsgroups... which
applies to everyone, you know the ones you ignore, not just MVP's.
Of
course, I probably won't get and answer from you...

Can anyone else tell me where these seperate rules are?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve" wrote in message
m...
Jeff,

As an MVP you have the responsibility to not only strive to behave
in
concordance with the MVP Rules of Conduct but to also admonish other
MVPs that breach the MVP Rules of Conduct. Do you condone the
conduct
of Visio John?

Regards,

Steve


"Jeff Boyce" -DISCARD-HYPHEN-TO-END wrote in
message ...
I strive to behave in concordance with the Rules of Conduct, so I'd
appreciate learning what is it about my "second post in this thread"
that you've interpreted as an attack on your proposed solution?

Regards

Jeff Boyce
Microsoft Access MVP

"Steve" wrote in message
m...
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






























 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.