Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×