Sorry about confusing the issue.
[the Control Source for this text box reads: =DatePart("m",[ApprovalDate])]
Your suggestions have me thinking the most straight forward solution is to
make the text box (named RenewalAnniversary) and it's label be visible only
when it's source - ApprovalDate has data.
So the question is how to make a text box visible when there is data,
otherwise remain invisible. Also, I am not 'enabling' changes to this text
box, if that has any bearing on my problem.

Thanks again,
Bill

"Linq Adams via AccessMonster.com" wrote:

"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