Printing A Report When Fields Are Blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Mc - 15 Nov 2004 23:41 GMT

I have run a query from my table and have a number of
text fields without any text filled in or are blank.

What is the "criteria" expression that I can use to not
print a field if the text field is blank, so that it will
not show on the report?

Thanks for your help.

Reply to this Message

Marshall Barton - 16 Nov 2004 00:37 GMT

>I have run a query from my table and have a number of
>text fields without any text filled in or are blank.
>
>What is the "criteria" expression that I can use to not
>print a field if the text field is blank, so that it will
>not show on the report?

Are you sure you want to exclude an entire record just
because one field doesn't have a value. If that's really
what you want to do then use the criteria IS NULL

If you just want to reclaim the space in the report that the
field's text box occupies, then the first thing to try is to
set the text box's and its section's CanShrink property to
Yes. If that's not adequate, then please post back with
more details.

Signature

Marsh
MVP [MS Access]

Reply to this Message