Is it possible to exclude empty fields in report?

C

CPhT

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.
 
D

Duane Hookom

If there are no values to print, how would you expect to exclude them? You
can use the "Can Shrink" property of controls.
 
C

CPhT

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.
 
D

Duane Hookom

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