Is it possible to exclude empty fields in report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you print a report, is it possible to automatically exclude fields in
the database that are not populated? I seem to remember that there is a way
to do this, but it has been 3 years since I took a beginner's Access class.
I am using Microsoft Office Access 2003. Any help would be greatly
appreciated.
 
If there are no values to print, how would you expect to exclude them? You
can use the "Can Shrink" property of controls.
 
Perhaps I should clarify: I am using Access for a family directory. As
things stand now, when the report is printed, the field labels still appear
even if some family members don't have things like a fax, a cell, or email.
I would like to exclude the labels for unused fields such as those listed
above if possible in order to have each person's entry take up as little
space as possible when the directory is printed.
 
You can change the fax "label" to a text box and set its control source to:
="Fax: " + [FaxField]
Make the text box only wide enough to show "Fax:" and don't allow it to
grow.

If the field [FaxField] is null, the text box will not show.
 
Back
Top