Access Controls  «Prev 

Combo Box and List Box Properties

MS Combo Properties
MS Combo Properties

1) Name
Name of the Combo Box or List Box control.
2) Control source
Field in the underlying record source of the form to use.
3) Row source type
Choices here are Table\Query, Value List, and Field List. It lets you specify how to populate the control.
4) Row source
Can be a SQL statement, a table or query name, or a list separated by semicolons.
5) Column count
Number of columns to use in the control from the row source.
6) Column heads
Includes a row in the control that will act as column headings.
7) Column widths
How wide do you want each column? A column width of zero doesn’t display anything, but the data is still available.
8) Bound column
The column in the row source to be entered into the control source.
9) List rows
Number of rows that will be displayed.
10) List width
Width of the displayed list.
11) Limit to list
Whether to require the data entered to be limited to the list.
12) Auto expand
Will search the list and move you to the next entry that matches the characters currently entered. If you are using a large row source for the list, you may want to set this to No for better performance