Description Property

Applies To   Action query, Crosstab query, Field object, Parameter query, Query field, QueryDef object, Select query, SQL-Specific query, Table, Table field, TableDef object.

Description

You can use the Description property to provide information about objects contained in the Database window as well as about individual table or query fields.

Setting

For a database object, click Properties on the View menu and enter the description text in the Description box. For tables or queries, you can also enter the description in the table's or query's property sheet. An object's description appears next to the object's name in the Database window when you click Details on the View menu.

For individual table or query fields, enter the field description in the upper portion of table Design view or in the Field Properties property sheet in the Query window. The maximum length is 255 characters.

In Visual Basic, to set this property for the first time you must create an application-defined property by using the DAO CreateProperty method.

Remarks

An object's description is displayed in the Description column in the Details view of the Database window.

If you create controls by dragging a field from the field list, Microsoft Access copies the field's Description property to the control's StatusBarText property.

Note For a linked table, Microsoft Access displays the connection information in the Description property.

See Also   Caption property, CreateProperty method ("DAO Language Reference"), Description property ("DAO Language Reference"), Object properties, StatusBarText property.