Topics Search

Text-Based Controls: The Label

Text-Based Controls: The Label
Views: 83
A label is a control that serves as a guide to the user. It provides a static text that the user cannot change but can read to get information about another control on the form. You can also use it to display simple information to the user. Most controls on the form are not explicit at first glance and the user would not know what they are. Therefore, you can assign a label to the control as a help to the user.
Topcis: The Label, The Text Box, The Command Buttons, Combo and List Boxes, Radio Buttons, Check Boxes and Toggle Buttons.
Sponsored Links:

Similar posts...

 

Data Controls: A Label

Data Controls: A Label Icon
A label is a control that serves as a guide to the user. It provides a static text that the user cannot change but can read to get information about another control on the form or report. You can also use it to display simple information to the user. Most controls on the form or the report are not explicit at first glance and the user would not know what they are. Therefore, you can assign a label to the control as a help to the user.
 

Hiding Controls on Form Open Based on IF Statement

Hiding Controls on Form Open Based on IF Statement Icon
I have a form that includes a large amount of controls and sub-forms. Throughout the form I have a lot of different After Update events which change the visible property of controls on the form based on the value in another control.

I.e. One of the controls has a label with the question 'Is the problem caused by a rain event?' and when the user selects 'yes' in the controlmore controls become visible which prompt the user for more information.

I have the same sort of thing set up on many controls in the form.

What I am trying to do now is get all of these individual controls to run when the form is opened - I.e. I am trying to write a script that will run the individual 'If' statements tohide/unhide controls based on the inputs stored in another control.

First of all I am not sure which event to run this on (I.e. On Open, On Load etc) and secondly I am not sure how to write a script that can handle multiple If statements that are notreliant on each other in the same event.
 

Windows Controls

Windows Controls Icon
A label is a control that serves as a guide to the user. It provides a static text that the user cannot change but can read to get information about another control on the form. You can also use it to display simple information to the user. Most controls on the form are not explicit at first glance and the user would not know what they are. Therefore, you can assign a label to the control as a help to the user.
 

Show Label & Text Box in Report based on Checkbox

Show Label & Text Box in Report based on Checkbox Icon
I am attempting to show a label and textbox based on a checkbox in a report. The report is based on a SQL query joining two tables. The checkbox field is included in the query. Currently in the properties, I have the label and textbox .visible = false. I would like to set the label and textbox to
visible when the checkbox response = Yes.

I tried the OnLoad event of the form

Private Sub Report_Load()
If Checkbox = "Yes" Then
Label.Visible = True
Textbox.Visible = True
End If
End Sub

This didn't work. I am unable to define the event for the textbox and label directly because this is a report and not a form.
 

The Windows Controls of a Form

The Windows Controls of a Form Icon
A typical database is made of forms (and reports) and these objects are equipped with Windows controls that allow a user to interact with the computer. To create such a database, you add forms and reports to it. Then you populate them with the necessary objects. This is the essence of application design and you should know how to design the controls.
Form and report design consists of populating them with the necessary controls that would allow a person to use your database. To perform this design, you first open the form or report in Design View.
Topics: Control Design, Common Properties of Controls, Tables Columns and Windows Controls, Common Methods of Windows Controls, Common Events of Windows Controls, Windows Controls: The Label, Windows Controls: The Group Box, Windows Controls: The Text Box, Windows Controls: The Month Calendar, Windows Controls: The Date Picker, Windows Controls: The Time Picker, Windows Controls: The Command Button, Combo and List Boxes, Check Boxes and Toggle Buttons.
 

How to hide a text field label when the field is null?

How to hide a text field label when the field is null? Icon
In MS Access 2003 report, how to hide the label attached to a text field when the text field is blank? Example: Field Name = [MiddleName]; the label for
[MiddleName] is [MidNameLbl]. If no middle name, I do not want the label to
 

Making Label visible based on checkbox

Making Label visible based on checkbox Icon
I am developing a driving safety checklist database for some co-workers and myself. So far I have one table that includes a few text boxes to get information like name, date, business purpose etc.

Then I have a few checkboxes, DUSK, DAWN, RAIN, SNOW ETC. Based on whether some of these boxes are checked, I want to be able to have a label displayed.

There will be 3 labels totaled, MINIMAL RISK, MEDIUM RISK, HIGH RISK. So for example if I fill out the form and if I have DUSK and RAIN checked, then the HIGH RISK label is visible and the othe r 2 labels are not etc.
 

Generating sequential records

Generating sequential records Icon
I have a form on which there are two controls, first label number and last label number. Say these values are 1000 and 3000. Then a button which will create a record for each label between these two values.
How do I create a sequential list of records like this, each with a label number (and some other data from the form,
 

Form label in a report

Form label in a report Icon
I created a form that basically is a launch point to a report. The form has a textbox for notes and a button to print the report. I have a label in the form which is a few lines of text, can I have the label show in the report? I put a text box in my report and the control source references the label in the form but when I print, nothing is displayed in the textbox in thereport.
 

Create string from selected controls on a form

Create string from selected controls on a form Icon
I have a form with five columns and 16 rows of controls. From left to right each row consists of a label, a bound and locked textbox populated from a query, two checkboxes and another unbound textbox.

jpg) of the form's state On Load. As you can see the right checkbox as well as the right textbox are visible = false. For explanation,I will use the following as control names:

Name checkbox = chkName (located under the label Name)
Title checkbox = chkTitle (located under the label Title, currently hidden in this example)
Title textbox = txtTitle (located under the label Please Include Title, currently hidden in this example)

This form is opened by double clicking a textbox on another form and is used to select the persons who have taken part in a recent survey at a hotel. If chkName for Row 1 is ticked, chkTitle for Row 1 becomes visible.

If chkTitle is ticked, the textbox under the label "Please include Title" becomes visible for Row 1. Unticking these reverses their visibility. txtTitle has a default value that can be overwritten.