Suppress label and text fields

J

JimO

I am developing a simple report from a table that may or
may not have data in various fields. How can I prevent
the label and corresponding text field from showing up on
the report? Thanks for your help
 
D

Duane Hookom

The text field will not show if there is nothing to show. To hide the label,
I change the label to a text box and set its control source to something
like:
="First Name: " + [empFirstName]
Make the text box just wide enough to display "First Name" and don't allow
it to grow. If the field is Null then the "label" control will disappear.
 
Top