A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Label Visibility



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2008, 09:06 PM posted to microsoft.public.access.forms
BillA
external usenet poster
 
Posts: 80
Default Label Visibility

What I thought was simple is starting to give me a headache.

Working with a form, 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.

Thank you for any advice.
Bill
  #2  
Old April 28th, 2008, 09:22 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Label Visibility

What kind of form; Single, Datasheet or Continuous View? What version of
Access?

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

  #3  
Old April 28th, 2008, 10:26 PM posted to microsoft.public.access.forms
BillA
external usenet poster
 
Posts: 80
Default Label Visibility

Sorry, the form is a single form.

Thank you for your interest.
Bill

"Linq Adams via AccessMonster.com" wrote:

What kind of form; Single, Datasheet or Continuous View? What version of
Access?

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1


  #4  
Old April 29th, 2008, 12:15 AM posted to microsoft.public.access.forms
BillA
external usenet poster
 
Posts: 80
Default Label Visibility

Realized I didn't state the version I am working with.
Access 2003, and it is a single form.

Thanks,
Bill

"Linq Adams via AccessMonster.com" wrote:

What kind of form; Single, Datasheet or Continuous View? What version of
Access?

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

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1


  #5  
Old April 29th, 2008, 01:27 PM posted to microsoft.public.access.forms
Linq Adams via AccessMonster.com
external usenet poster
 
Posts: 1,474
Default Label Visibility

"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

  #6  
Old April 29th, 2008, 02:28 PM posted to microsoft.public.access.forms
BillA
external usenet poster
 
Posts: 80
Default Label Visibility

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


  #7  
Old April 29th, 2008, 04:25 PM posted to microsoft.public.access.forms
BillA
external usenet poster
 
Posts: 80
Default Label Visibility

I've figured out my problem (I hope) the following code placed in the form's
"On Current" event has given me what I was looking for.

Private Sub Form_Current()
Me.RenewalAnniversary.Visible = Not IsNull(Me.ApprovalDate)
End Sub

With the (RenewalAnniversary) text box visible set to 'no' this code works
for me.

Thanks,
Bill

"BillA" wrote:

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:59 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.