Hide label on report printout when no text box is blank

[JuztinMedia]

I am creating a contact list database. It includes: Name, Address, City, State, Zip, Home Phone, Cell Phone, Pager, Fax, E-mail.

I want all of this information to appear on my report. However, some people do not have a cell phone, pager, or a fax. For those who do not have one of the above numbers, when the report prints out it shows "Cell" and then a blank space.

How do I hide a label on a report of a text field that is blank?

Please help!

 

[Bry12345]

Check this thread:

thread703-255537 - - - -

Bry