Hide label

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi

How can I hide a label in a report if the value of the
data is null

thanks
 
Chris said:
How can I hide a label in a report if the value of the
data is null
Click to expand...


Use a little VBA code in the Format event of the section
containing the text box.

Me.thetextbox.Visible = Not IsNull(Me.thetextbox)
 
Or convert the label to a text box and set its control source to:
="My Caption " + [MyField]
Make sure the text box is wide enough to only show what you want and set Can
Grow to No.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Empty/null field, hide label (?) 2
How to hide a text field label when the field is null? Access2003 3
Custom Label Report? 2
hide labels in report for zero fields 2
hide label in subreport within report 7
hide label & checkbox if ..... 8
hide label if no data 3
Hide a label 5

Back
Top