(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.
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.
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.
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.
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.
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.
Shows which column is bound to the underlying field for a bound multicolumn list box or combo box.
Shows the number of columns on a list box or combo box.
Shows the width of each column, separated by semicolons. To hide the bound column from the display, use a width value of zero.
Shows the maximum number of rows to display in the list box portion of a combo box.
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.