M Marshall Barton Dec 9, 2003 #2 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)
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 Dec 10, 2003 #3 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.
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.
