What Type of Form Control Is Normally Used to Display Data?

MS Access - Controls & Properties

In this chapter, we volition exist covering Controls and Properties available in Access. We will also learn how to add controls to forms. Controls are the parts of a form or written report that you employ to enter, edit, or display data. Controls let you view and piece of work with information in your database awarding.

The most ofttimes used control is the text box, but other controls include command buttons, labels, check boxes, and subform/subreport controls.
There are unlike kinds and types of controls you can create, but all of which will autumn into one of the two categories — spring or unbound.

Bound Controls

Permit us now understand what Bound Controls are −

Bound controls are ones that are tied to a specific information source within your database such as a field and a table or a query.
Values tin can be either text, dates, number, check boxes, pictures or fifty-fifty graphs.
Y'all utilize jump controls to display values that come from fields in your database.

Unbound Controls

Let us at present understand what Unbound Controls are −

Unbound controls on the other hand are not tied to a information source, and they exist only in the form itself.
These can be text, pictures or shapes such as lines or rectangles.

Control Types

You tin create different types of controls in Admission. Here, we will discuss a few mutual ones such equally Text box, Characterization, Button Tab Controls etc.

Text Box

Typically, anything that is in a text box will be spring, simply non always.
Y'all can apply these controls to interact with the data stored in your database, but you lot tin can also take unbound text boxes.
Calculated controls volition perform some kind of calculation based on an expression that you write and that data is non stored anywhere in your database.
It is calculated on the wing and live only on that ane form.

Labels

Labels will e'er be text and unbound.
Unremarkably, labels are not connected to any source in your database.
Labels are used to label other controls on your class such equally text boxes.

Push

This is another blazon of popular control; these command buttons usually perform a macro or module.
Buttons are usually used to interact with the information or objects inside your database.

Tab Controls

Tab controls requite yous a tabbed view of controls or other controls in your class.
Adding tabs to a course can make it more organized and piece of cake to utilise, particularly if the course contains many controls.
By placing related controls on separate pages of the tab command, you can reduce clutter and ease your piece of work with information.

Hyperlink

Hyperlink creates a hyperlink on your form to something else. Information technology can either be a spider web folio or even another object or place within your database.

Another Controls

Let usa at present look into some other controls −

Yous tin can likewise create a web browser command and navigation control, groups, page breaks, combo boxes.
Yous tin create charts, lines, toggle buttons, list boxes, rectangles, check boxes, unbound object frames, attachments, option buttons, subforms and subreports, bound object frames and fifty-fifty place images on your form.

Example

Allow u.s.a. now look at a simple example of some of these controls by creating a new blank form. Go to the Create tab in the forms group and click on Bare Class.

Blank Form

The to a higher place footstep will open an unbound grade, which is non attached withal to any item in our database.

Field List

Past default, it will open in layout view every bit shown in the above screenshot.

Permit us now get to the Design View to add fields.

Add Design Fields

On the Design tab, click on the Belongings Sheet.

Property Sheet Design

On the Holding Sheet, click on the drop-down arrow and make sure Grade is selected, and then get to the Information tab.

Details Property

On the Information tab, y'all will see that the Record Source remains blank. Let us assume, we desire to create a grade that'south going to be tied to two dissimilar tables in our database. Now click on … button. It will further open its own query builder.

Query Builder

Select the tables that contain the information yous want to brandish; click on the Add together button and and so shut this dialog box.

Select Property Sheet

Let us at present select all the fields from tblEmployees and drag to query filigree, and similarly add all the fields from tblHRData.

Now, click Salve As and give this query a name.

Query2 Save

Allow us call it qryEmployeesData and click Ok and so close the query architect.

Employee Data

Yous can now encounter the query as its Record Source. We take now bound this form to an object in our database, in this case qryEmployeesData. Nosotros can at present start by adding some controls to this form and to add any one of the controls, get to the Design tab and view your options from the controls group.

Use Control Wizard

From the Controls menu, you will see that the Use Control Wizard is highlighted as in the above screenshot. This piddling button has that highlighted box around information technology past default. This ways that the control wizards are turned on. This is similar a toggle switch. When you click on the toggle switch the wizards turn off. Clicking information technology once again volition plow the wizards on.

Let us now click on the Label and drag this label and enter Employee Information and then get to the Format tab to format it as in the post-obit screenshot.

Detail Employee Information

Yous can cull to utilise a bold style or alter the font size of text within that label etc. This control appears within the particular section of your form. It makes more sense to position this label inside the form header section, which is not visible yet.

Header Section

Correct click anywhere in the groundwork of that form and cull Form Header as in the in a higher place screenshot.

Form Header

Move this control into the Form Header surface area. Let u.s. now create some other controls from the Design tab. At this point, Let usa say, nosotros want to distribute all our fields into two different tabs.

Header Area

From the command menu, you tin see the Tab Control which will create tabs on your form. Click on the tab command and draw information technology on your course in the detail section as in the in a higher place screenshot.

Tab Control

It volition create ii tabs — page 2 and page iii as in the above screenshot.

Let us now start by adding some controls to this tab control.

If we want to view some information that's stored in our underlying query, click on the Add together Existing Fields option from the Ribbon in Tools group to view all the bachelor fields from our underlying query.

Existing Fields