L
Lynn
Is there a way to suppress a field if it is blank? If so, how?
J
Jeff Boyce
Define "blank"... No, really!
Blank might mean you can't see what was stored in the field.
Blank might mean that there's a zero-length string ("") stored in the field.
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null).
Which one(s) are you asking about?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Blank might mean you can't see what was stored in the field.
Blank might mean that there's a zero-length string ("") stored in the field.
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null).
Which one(s) are you asking about?
Regards
Jeff Boyce
Microsoft Office/Access MVP
L
Lynn
Nothing has ever been stored in the field ... There is a comments field in my
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps
J
Jeff Boyce
Lynn
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been something
in the field.
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though...
If you have nothing in the field, what is it that you are trying to supress?
Regards
Jeff Boyce
Microsoft Office/Access MVP
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been something
in the field.
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though...
If you have nothing in the field, what is it that you are trying to supress?
Regards
Jeff Boyce
Microsoft Office/Access MVP
L
Lynn
In my database, there is a table that stores survey results. One of the
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on the
report (representing all the records where no comment was entered). I would
like to suppress this white space. Any suggestions? Thanks!
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on the
report (representing all the records where no comment was entered). I would
like to suppress this white space. Any suggestions? Thanks!
J
Jeff Boyce
Lynn
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
D
Dave C
Check out the CanShrink and CanGrow properties. I think a combination of
these will give you what you want... a comments field that's only as high as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
these will give you what you want... a comments field that's only as high as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
T
Thomas Roman
Wow this Jeff character is a big help, 1 suggestion Jeff, READ. What are you 12 years old?
Jeff Boyce wrote:
LynnPerchance have you based your report directly on the table?
18-Jul-08
Lyn
Perchance have you based your report directly on the table
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put
Not Null (Access changes this to "Is Not Null"
Add any other fields you want to have show in your report
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to
Is Not Null and <> "
When the query is returning only those you want to see, base your report on
the query
Regard
Jeff Boyc
Microsoft Office/Access MV
Previous Posts In This Thread:
Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?
Define "blank"... No, really!
Define "blank"... No, really
Blank might mean you can't see what was stored in the field
Blank might mean that there's a zero-length string ("") stored in the field
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null)
Which one(s) are you asking about
Regard
Jeff Boyc
Microsoft Office/Access MV
Nothing has ever been stored in the field ...
Nothing has ever been stored in the field ... There is a comments field in my
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps:
:
LynnYou will want to double-check.
Lyn
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been something
in the field
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though..
If you have nothing in the field, what is it that you are trying to supress
Regard
Jeff Boyc
Microsoft Office/Access MV
In my database, there is a table that stores survey results.
In my database, there is a table that stores survey results. One of the
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on the
report (representing all the records where no comment was entered). I would
like to suppress this white space. Any suggestions? Thanks
:
LynnPerchance have you based your report directly on the table?
Lyn
Perchance have you based your report directly on the table
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put
Not Null (Access changes this to "Is Not Null"
Add any other fields you want to have show in your report
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to
Is Not Null and <> "
When the query is returning only those you want to see, base your report on
the query
Regard
Jeff Boyc
Microsoft Office/Access MV
Check out the CanShrink and CanGrow properties.
Check out the CanShrink and CanGrow properties. I think a combination of
these will give you what you want... a comments field that's only as high as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorial...05-5995f2b0ab63/sharepoint-video-library.aspx
Jeff Boyce wrote:
LynnPerchance have you based your report directly on the table?
18-Jul-08
Lyn
Perchance have you based your report directly on the table
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put
Not Null (Access changes this to "Is Not Null"
Add any other fields you want to have show in your report
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to
Is Not Null and <> "
When the query is returning only those you want to see, base your report on
the query
Regard
Jeff Boyc
Microsoft Office/Access MV
Previous Posts In This Thread:
Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?
Define "blank"... No, really!
Define "blank"... No, really
Blank might mean you can't see what was stored in the field
Blank might mean that there's a zero-length string ("") stored in the field
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null)
Which one(s) are you asking about
Regard
Jeff Boyc
Microsoft Office/Access MV
Nothing has ever been stored in the field ...
Nothing has ever been stored in the field ... There is a comments field in my
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps:
:
LynnYou will want to double-check.
Lyn
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been something
in the field
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though..
If you have nothing in the field, what is it that you are trying to supress
Regard
Jeff Boyc
Microsoft Office/Access MV
In my database, there is a table that stores survey results.
In my database, there is a table that stores survey results. One of the
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on the
report (representing all the records where no comment was entered). I would
like to suppress this white space. Any suggestions? Thanks
:
LynnPerchance have you based your report directly on the table?
Lyn
Perchance have you based your report directly on the table
Try this ... create a query against that table. In the selection criterion
for the [Comment] field, put
Not Null (Access changes this to "Is Not Null"
Add any other fields you want to have show in your report
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to
Is Not Null and <> "
When the query is returning only those you want to see, base your report on
the query
Regard
Jeff Boyc
Microsoft Office/Access MV
Check out the CanShrink and CanGrow properties.
Check out the CanShrink and CanGrow properties. I think a combination of
these will give you what you want... a comments field that's only as high as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorial...05-5995f2b0ab63/sharepoint-video-library.aspx
D
Douglas J. Steele
Do you7 have a specific complaint with Jeff's answer?
And, for that matter, why are you complaining (giving Lynn posted the
question)?
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
And, for that matter, why are you complaining (giving Lynn posted the
question)?
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Wow this Jeff character is a big help, 1 suggestion Jeff, READ. What are
you 12 years old?
Jeff Boyce wrote:
LynnPerchance have you based your report directly on the table?
18-Jul-08
Lynn
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection
criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report
on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Previous Posts In This Thread:
Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?
Define "blank"... No, really!
Define "blank"... No, really!
Blank might mean you can't see what was stored in the field.
Blank might mean that there's a zero-length string ("") stored in the
field.
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null).
Which one(s) are you asking about?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Nothing has ever been stored in the field ...
Nothing has ever been stored in the field ... There is a comments field in
my
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps
:
LynnYou will want to double-check.
Lynn
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been
something
in the field.
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though...
If you have nothing in the field, what is it that you are trying to
supress?
Regards
Jeff Boyce
Microsoft Office/Access MVP
In my database, there is a table that stores survey results.
In my database, there is a table that stores survey results. One of the
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on
the
report (representing all the records where no comment was entered). I
would
like to suppress this white space. Any suggestions? Thanks!
:
LynnPerchance have you based your report directly on the table?
Lynn
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection
criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report
on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Check out the CanShrink and CanGrow properties.
Check out the CanShrink and CanGrow properties. I think a combination of
these will give you what you want... a comments field that's only as high
as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorial...05-5995f2b0ab63/sharepoint-video-library.aspx
J
Jeff Boyce
Why would he be upset with me?...<g>
Regards
Jeff Boyce
Microsoft Access MVP
Regards
Jeff Boyce
Microsoft Access MVP
J
Jeff Boyce
Thomas
I'm always open to learning something new. Is there anything in particular
I missed?
(and no, I may act like a 12 year old, but I have a few more years on me
than that ... oh wait, was that an ad hominem attack?!)
Jeff B.
I'm always open to learning something new. Is there anything in particular
I missed?
(and no, I may act like a 12 year old, but I have a few more years on me
than that ... oh wait, was that an ad hominem attack?!)
Jeff B.
Wow this Jeff character is a big help, 1 suggestion Jeff, READ. What are
you 12 years old?
Jeff Boyce wrote:
LynnPerchance have you based your report directly on the table?
18-Jul-08
Lynn
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection
criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report
on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Previous Posts In This Thread:
Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?
Define "blank"... No, really!
Define "blank"... No, really!
Blank might mean you can't see what was stored in the field.
Blank might mean that there's a zero-length string ("") stored in the
field.
Blank might mean that "nothing" has ever been stored in the field (i.e.,
Null).
Which one(s) are you asking about?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Nothing has ever been stored in the field ...
Nothing has ever been stored in the field ... There is a comments field in
my
report. Some records have a comment entered & some don't. I want to
suppress the comments that are blank. Hope this helps
:
LynnYou will want to double-check.
Lynn
You will want to double-check. Someone could have entered a comment and
then hit <Esc> or highlighted it and <Del>. I'm pretty sure at least the
latter will result in a zero-length string because there HAS been
something
in the field.
You posted in a reports newsgroup, so I'll assume you're trying to do this
in a report. I'm still a little fuzzy, though...
If you have nothing in the field, what is it that you are trying to
supress?
Regards
Jeff Boyce
Microsoft Office/Access MVP
In my database, there is a table that stores survey results.
In my database, there is a table that stores survey results. One of the
fields in this table is a Comment field. Not everyone that fills out the
survey enters a comment, therefore, this field will be "blank" for some of
the records but not for others. I am creating a report that will display
all the survey comments so I have added the Comment field to the details
section of my report. The result, however, is a bunch of white space on
the
report (representing all the records where no comment was entered). I
would
like to suppress this white space. Any suggestions? Thanks!
:
LynnPerchance have you based your report directly on the table?
Lynn
Perchance have you based your report directly on the table?
Try this ... create a query against that table. In the selection
criterion
for the [Comment] field, put:
Not Null (Access changes this to "Is Not Null")
Add any other fields you want to have show in your report.
Run the query ... if you still get "blanks", you probably have zero-length
strings, too. Change your selection criterion to:
Is Not Null and <> ""
When the query is returning only those you want to see, base your report
on
the query.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Check out the CanShrink and CanGrow properties.
Check out the CanShrink and CanGrow properties. I think a combination of
these will give you what you want... a comments field that's only as high
as
it needs to be to contain the data that was entered, and is skipped if
nothing is entered.
:
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorial...05-5995f2b0ab63/sharepoint-video-library.aspx
S
Steve
No, it is Arno R trying to stir up trouble.
Steve
Steve
PieterLinden via AccessMonster.com said:
A
Arno R
Steve said:
It's not me buddy...
sorry Mistake... I am not your buddy.
Regards, Arno R
S
Steve
Do not believe this guy Arno R. He is only out to cause trouble in the
newsgroups. Check to see how many times he responds to help anyone. Watch
and you will next see visio john and/or keith wilby chime in to defend Arno
R. The three are conspiriitors who have do nothing for the newsgroups to
help posters.
Steve
newsgroups. Check to see how many times he responds to help anyone. Watch
and you will next see visio john and/or keith wilby chime in to defend Arno
R. The three are conspiriitors who have do nothing for the newsgroups to
help posters.
Steve
J
John... Visio MVP
"who have do nothing "?
So eloquent. Spoken like a true expert.
So eloquent. Spoken like a true expert.
S
Steve
Watch and you will next see visio john ............
It's not hard to predict the conduct of this guy !!!!!
Keep watching for keith wilby.
Steve
It's not hard to predict the conduct of this guy !!!!!
Keep watching for keith wilby.
Steve
S
Steve
This guy says "I ALWAYS use my own name." It's obvious he is not telling the
truth when you look at the name of who sent this post.
Then ask yourself what else is he saying that is not true. He says "....
it's not me who has posted this crap."
Yes, he says ".... it's not me who has posted this crap." Look at the email
address he uses then ask yourself again what else is he saying that is not
true.
Steve
truth when you look at the name of who sent this post.
Then ask yourself what else is he saying that is not true. He says "....
it's not me who has posted this crap."
Yes, he says ".... it's not me who has posted this crap." Look at the email
address he uses then ask yourself again what else is he saying that is not
true.
Steve
L
Larry Linson
Steve said:
He always signs his posts Arno R. He uses an obviously fake e-mail to avoid
spam, as do most others, including yourself even when you post as Steve. But
he doesn't post under some other name, as you have been shown to do by the
content of your message headers, which has been documented right in the
newsgroups.
He and the OP do not have the same posting host. Just what did you have in
mind, Steve? Just to stir up a little trouble? Just to spread a little
dissension and discontent? Just to do a little trolling?
Larry Linson