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  

Suppress if blank



 
 
Thread Tools Display Modes
  #1  
Old July 18th, 2008, 04:15 PM posted to microsoft.public.access.reports
Lynn
external usenet poster
 
Posts: 428
Default Suppress if blank

Is there a way to suppress a field if it is blank? If so, how?
  #2  
Old July 18th, 2008, 04:45 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Suppress if blank

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

"Lynn" wrote in message
...
Is there a way to suppress a field if it is blank? If so, how?



  #3  
Old July 18th, 2008, 05:20 PM posted to microsoft.public.access.reports
Lynn
external usenet poster
 
Posts: 428
Default Suppress if blank

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

"Jeff Boyce" wrote:

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

"Lynn" wrote in message
...
Is there a way to suppress a field if it is blank? If so, how?




  #4  
Old July 18th, 2008, 07:01 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Suppress if blank

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

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

"Jeff Boyce" wrote:

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

"Lynn" wrote in message
...
Is there a way to suppress a field if it is blank? If so, how?






  #5  
Old July 18th, 2008, 07:37 PM posted to microsoft.public.access.reports
Lynn
external usenet poster
 
Posts: 428
Default Suppress if blank

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!

"Jeff Boyce" wrote:

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

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

"Jeff Boyce" wrote:

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

"Lynn" wrote in message
...
Is there a way to suppress a field if it is blank? If so, how?






  #6  
Old July 18th, 2008, 08:01 PM posted to microsoft.public.access.reports
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Suppress if blank

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

"Lynn" wrote in message
...
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!

"Jeff Boyce" wrote:

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

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

"Jeff Boyce" wrote:

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

"Lynn" wrote in message
...
Is there a way to suppress a field if it is blank? If so, how?








  #7  
Old July 21st, 2008, 09:53 PM posted to microsoft.public.access.reports
Dave C
external usenet poster
 
Posts: 66
Default Suppress if blank

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.

"Lynn" wrote:

Is there a way to suppress a field if it is blank? If so, how?

  #8  
Old March 30th, 2010, 06:56 PM posted to microsoft.public.access.reports
Thomas Roman
external usenet poster
 
Posts: 1
Default Wow what a help this guy is

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

"Lynn" wrote in message
...

Previous Posts In This Thread:

On Friday, July 18, 2008 11:15 AM
Lyn wrote:

Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?

On Friday, July 18, 2008 11:45 AM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Friday, July 18, 2008 12:20 PM
Lyn wrote:

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

"Jeff Boyce" wrote:

On Friday, July 18, 2008 2:01 PM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Friday, July 18, 2008 2:37 PM
Lyn wrote:

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!

"Jeff Boyce" wrote:

On Friday, July 18, 2008 3:01 PM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Monday, July 21, 2008 4:53 PM
Dave wrote:

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.

"Lynn" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials...o-library.aspx
  #9  
Old March 30th, 2010, 10:44 PM posted to microsoft.public.access.reports
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Wow what a help this guy is

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
http://I.Am/DougSteele
(no private e-mails, please)


Thomas Roman wrote in message ...
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

"Lynn" wrote in message
...

Previous Posts In This Thread:

On Friday, July 18, 2008 11:15 AM
Lyn wrote:

Suppress if blank
Is there a way to suppress a field if it is blank? If so, how?

On Friday, July 18, 2008 11:45 AM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Friday, July 18, 2008 12:20 PM
Lyn wrote:

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

"Jeff Boyce" wrote:

On Friday, July 18, 2008 2:01 PM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Friday, July 18, 2008 2:37 PM
Lyn wrote:

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!

"Jeff Boyce" wrote:

On Friday, July 18, 2008 3:01 PM
Jeff Boyce wrote:

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

"Lynn" wrote in message
...

On Monday, July 21, 2008 4:53 PM
Dave wrote:

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.

"Lynn" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials...o-library.aspx



  #10  
Old March 31st, 2010, 02:38 AM posted to microsoft.public.access.reports
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Wow what a help this guy is

Douglas J. Steele wrote:
Do you7 have a specific complaint with Jeff's answer?

And, for that matter, why are you complaining (giving Lynn posted the
question)?

Wow this Jeff character is a big help, 1 suggestion Jeff, READ. What are
you 12 years old?

[quoted text clipped - 136 lines]
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorials...o-library.aspx


Is it Steve in disguise?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201003/1

 




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 02:39 PM.


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