Using combo boxes and list boxes
Access has two types of controls—list boxes and combo boxes—that enable you to show lists of data from which a user can select. The list box is always open and ready for selection, whereas the combo box has to be clicked to open the list for selection. Also the combo box enables you to enter a value that is not on the list and takes up less room on the form.
You may want to replace the Category text box with a combo box containing values from tblCategories, as shown in Figure 35-29. The easiest way to do this is with the Combo Box Wizard. This wizard walks you through the steps of creating a combo box that looks up values in another table. To create a combo box, switch to Design View and select the Combo Box command from the Design tab’s Controls group. Make sure the Use Control Wizards command is selected.
FIGURE 35-29
Using a combo box to select value from a list.
After you create the combo box, examine the Row Source Type, Row Source, Column Count, Column Heads, Column Widths, Bound Column, List Rows, and List Width properties. Once you become familiar with setting these properties, you can right-click a text box, select Change To?Combo Box, and set the combo box’s properties manually.
// Related Posted - GOOGLE!
Related Websites
- Fjaril: Dynamic Drawers View furniture to original versions always an interesting and rewarding activity. While it is almost impossible to access the original...
- Open a Beer Bottle with a Piece of Bread, and 999 Other Ways Okay, this is not my original list, but this IS a life-saving list worth mentioning. Studying this list will result...
- How to Install Window Boxes Window boxes add charm to any home and they are so easy to install that anyone can do it. You're...
- How to Find IP Address on Computer [/caption]Each and every device that is connected to internet is associated with a unique number which is referred to as...
- Sierra MatchKing Boat Tail Hollow Point 270 Cal 135 Grain 100/Box Boat Tail Hollow PointBoat Tail Hollow Point 270 Winchester100 Per Box Product DescriptionFor serious rifle competition, you'll be in championship...
