BoundValue property
Contains the value of a control when that control receives the focus.
Syntax
object.BoundValue [= Variant ]
The BoundValue property syntax has these parts:
| Part | Description |
|---|---|
| object | Required. A valid object. |
| Variant | Optional. The current state or content of the control. |
Settings
| Control | Description |
|---|---|
| CheckBox | An integer value indicating whether the item is selected: Null. Indicates the item is in a null state, neither selected nor cleared. -1 True. Indicates the item is selected. 0 False. Indicates the item is cleared. |
| OptionButton | Same as CheckBox. |
| ToggleButton | Same as CheckBox. |
| ScrollBar | An integer between the values specified for the Max and Min properties. |
| SpinButton | Same as ScrollBar. |
| ComboBox, ListBox | The value in the BoundColumn of the currently selected rows. |
| CommandButton | Always False. |
| MultiPage | An integer indicating the currently active page. Zero (0) indicates the first page. The maximum value is one less than the number of pages. |
| TextBox | The text in the edit region. |
Remarks
BoundValue applies to the control that has the focus.
The contents of the BoundValue and Value properties are identical most of the time. When the user edits a control so that its value changes, the contents of BoundValue and Value are different until the change is final.
Several things occur when the user changes the value of a control. For example, if a user changes the text in a TextBox, the following things occur:
The Change event is initiated. At this time the Value property contains the new text and BoundValue contains the previous text.
The BeforeUpdate event is initiated.
The AfterUpdate event is initiated. The values for BoundValue and Value are once again identical, containing the new text.
BoundValue cannot be used with a multi-select list box.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.