SECTION 3
Lesson 3.2: Advanced Form Controls

   

 

 

Let’s take a look at the Categories form in the sample database:

 

 

The current category of product is listed at the top of the form, as well as a picture of the category. There is also a listing of all products that fall into the current category. At the very bottom of the form window, you can click the (<) and (>) buttons to advance to different categories.

Now take a look at the Categories table in Datasheet view:

 

 

You can see the Description field stating the types of products that can be found in each category. If you recall, this category description is visible in the form. First, open the form in Design view:

 

 

Now click the Description box (not the label) and click the Properties icon () on the form design toolbar:

 

 

As you can see, there is no shortage of things to modify! As an aside, notice how the Control Source field has the Description field of the Categories table as the source for its data. We will cover how to modify the data source of a control in the next section of this lesson.

The tabs at the top of the window help categorize this large list into more manageable pieces.

 

Format Tab

Controls how an object will look.

Data Tab

Add a validation rule, make a default value, modify the control source, etc.

Event Tab

Controls what a particular object will do when you interact with it (click it, move the mouse over it, etc)

Other Tab

Alternate controls like allowing AutoCorrect, adjusting the tab order, etc.

All Tab

All controls combined.

 

You can modify the values in the Properties dialogue box be entering a value directly, picking a Yes or No option, or selecting an option from a combo box.