Lookup Property Page (ADP)

(Microsoft SQL Server 2000 only.) This property page contains a set of properties pertaining to lookup fields. This property page applies to tables, views, and in-line functions.

Table Name

Appears only if you are working on a table. Shows the name of the table. If you are working in a database diagram and more than one table is selected in it, only the name of the first table is visible.

Object Name

Appears only if you are working on a view or in-line function. Shows the name of the view or function. You cannot edit this property.

Column Name

If you are working on a table, shows the name of a column within that table. If you are working on a view or in-line function, shows the name of an output column for that view or function. To inspect the lookup properties for a different column, choose from the drop-down list.

Display Control

Shows the default control for displaying values of this column when you include it on a form.

Row Source Type

Works together with the Row Source property. Use this property to specify the type of row source (table/query, value list, field list, or Visual Basic function) and then specify the actual row source in the Row Source property.

Row Source

If Row Source Type is set to Table/Query, shows the name of the table, query, or SQL statement. Although stored procedures are not displayed, you can enter the name of a single-statement stored procedure that does not modify data.

If Row Source Type is set to Value List, shows the entries in the list, separated by semicolons.

If Row Source Type is set to Field List, shows the name of the table or query.

If Row Source Type is set to Function Name, Row Source is blank.

Bound Column

Shows which column is bound to the underlying field for a bound multicolumn list box or combo box.

Column Count

Shows the number of columns on a list box or combo box.

Column Widths

Shows the width of each column, separated by semicolons. To hide the bound column from the display, use a width value of zero.

List Rows

Shows the maximum number of rows to display in the list box portion of a combo box.

List Width

Shows the width of the list box portion of a combo box.

Limit To List

Determines whether a combo box accepts any entered text or only text that matches one of the values in the list.