Hide label

M

Marshall Barton

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

Duane Hookom

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.
 

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

Trying to create custom labels from an csv file + Need items numerically counted out 0
Blank Page After Envelope-Label Wizard 5
Hiding Data Labels for 0 Values in Pie Chart 0
Mail merge labels 8 per page, but 84 is not divisible by 8 3
ASK Field Formatting 1
How to hide a text field label when the field is null? Access2003 2
Program buttons to create a word document 0
cannot find which label format i need 1

Top