Which of the following properties binds the forms and reports to a source from which data is to be
retrieved?
A.
RecordSource
B.
ControlSource
C.
Can Grow
D.
RowSource
Explanation:
The RecordSource property belongs to the form and report objects. This property binds the object to
a source from which data is to be retrieved. This source can be a table or a query. When a form or a
report is bound to a table or a query, the controls can be bound to a column of the table through the
ControlSource property.
Answer C is incorrect. The Can Grow property allows a control to adjust its dimensions according to
the contents present in the control. A control grows vertically to adjust its contents so that all the
contents can be displayed. The default value of the Can Grow property is false.
Answer B is incorrect. The ControlSource property bounds a control to a field of a table. If a control
is bound to a field by using this property, the control is known as a bound control. If the value of thisproperty is blank, the control is known as an unbound control. If the ControlSource property
contains an expression, the control is known as a calculated control.
Answer D is incorrect. The RowSource property belongs to the combo box and list box controls.
When these controls are bound to a column by the RowSource property, all the data of the column
is displayed in the list box or the combo box.
ControlSource property to specify what data appears in a control. You can display and edit data bound to a field in a table, query, or SQL statement. You can also display the result of an expression. Read/write String.
B is incorrect. The ControlSource property bounds a control to a field of a table.