How conditionally skip stuff on a report?

[ray anselmi]

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/tutorial...1-04094072c374/how-to-detect-and-automat.aspx

 

[Jeff Boyce]

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.

 

[Steve]

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
(e-mail address removed)

 

[Jeff Boyce]

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]

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
(e-mail address removed)

 

[Jeff Boyce]

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]

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]

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]

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

 

[John... Visio MVP]

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

 

[Jeff Boyce]

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

 

[Jeff Boyce]

Ray

Do you have a solution to your question?


--

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]

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

 

[John... Visio MVP]

You are paranoid. I was responding to you and only you. So does "done and
over" really mean you are going to stop pimping your services? I doubt it.

John... Visio MVP

 

[Steve]

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

 

[Gina Whipp]

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

 

[Jeff Boyce]

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.

 

[Jeff Boyce]

.... 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]

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

 

[Steve]

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