"I have a label assigned to a text box. The text box source is a field
(field: ApprovalDate) that I'm using only the month (DatePart function and
formatted mmmm) to give me an anniversary date of the approved date. This
field may or may not have a data entered. I would like to have the label to
this text box be visible only if there is data in this field. The text box
is named RenewalAnniversary. The label named RenewalAnniversaryLabel.

Re-reading your original post has given me a headache, too, Bill! Are you
saying that if

ApprovalDate

has data you want RenewalAnniversaryLabel visible, or are you saying that if


RenewalAnniversary

has data in it you want its label to be visible?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com