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 (
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.
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. |