Solved

How do I change the visibility of a Label and Textbox after a Yes/No Option?

Posted on 2008-06-19
3
185 Views
Last Modified: 2013-11-28
Hello Experts!!!

I have a Form, on the Form, I have a check box (ItemsReceived).  When the box is checked, I want a Label & Text box to pop up (Label20, DateItemsReceived).
How do I set the visibility for both label and textbox to be set when the check box is checked?  Also, would it be easy to add a few more labels and text boxes later on?

Thanks for all your help!!!!!!  
0
Comment
Question by:MissC_9880
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
Tirocupidus earned 250 total points
ID: 21825260
In the OnClick event of the checkbox, you would use the code I'm posting. If the label is the one associated with the textbox, then you can delete the line for it since hiding a control will automatically hide its associated label.
Me.Label20.Visible = Me.checkbox
Me.DateItemsReceived.Visible = Me.checkbox

Open in new window

0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 21825275
in the click or change or afterupdate  event  of the check box

private sub chkbox_click()


me.label20.visible=(me.chkbox=true)
me.DateItemsreceived.visible=(me.chkbox=true)

end sub
0
 

Author Closing Comment

by:MissC_9880
ID: 31468931
Worked perfectely!!!  Thanks so much for your help and your quick response!!!
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question