Suppress label and text fields

  • Thread starter Thread starter JimO
  • Start date Start date
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
 
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.
 
Back
Top