Printing A Report When Fields Are Blank

  • Thread starter Thread starter Mike Mc
  • Start date Start date
M

Mike Mc

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.
 
Mike said:
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?
Click to expand...


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.
 
Back
Top