title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
CustomControl.ControlSource property (Access) |
vbaac10.chm12009 |
|
|
1f773a09-7bcc-45ec-9380-3ab5ee13f024 |
02/21/2019 |
medium |
Use the 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.
expression.ControlSource
expression A variable that represents a CustomControl object.
The ControlSource property uses the following settings.
Setting | Description |
---|---|
A field name | The control is bound to a field in a table, query, or SQL statement. Data from the field is displayed in the control. Changes to the data inside the control change the corresponding data in the field. (To make the control read-only, set the Locked property to Yes.) If you choose a control bound to a field that has a Hyperlink data type, you jump to the destination specified in the hyperlink address. |
An expression | The control displays data generated by an expression. This data can be changed by the user but isn't saved in the database. |
For reports, the ControlSource property applies only to report group levels.
Forms and reports act as "windows" into your database. You specify the primary source of data for a form or report by setting its RecordSource property to a table, query, or SQL statement. You can then set the ControlSource property to a field in the source of data or to an expression.
If the ControlSource property setting is an expression, the value displayed is read-only and not saved in the database. For example, you can use the following settings.
Sample setting | Description |
---|---|
LastName | For a control, data from the LastName field is displayed in the control. For a report group level, Microsoft Access groups the data on last name. |
=Date( ) + 7 |
For a control, this expression displays a date seven days from today in the control. |
=DatePart("q",ShippedDate) |
For a control, this expression displays the quarter of the shipped date. For a report group level, Access groups the data on the quarter of the shipped date. |
The following example sets the ControlSource property for a text box named AddressPart to a field named City.
Forms!Customers!AddressPart.ControlSource = "City"
The following example sets the ControlSource property for a text box named Expected to the expression =Date() + 7
.
Me!Expected.ControlSource = "=Date() + 7"
[!includeSupport and feedback]