Microsoft Office Tutorials and References
In Depth Information
You can hide the characters entered into a text box by specifying a value for the PasswordChar
property. This property is typically used to hide password information. Typically, an asterisk
(*) is used for this property. Set this property to the empty string to display the actual char
The MaxLength property specifies the maximum number of characters that can be entered
into the Te xtBox , and the Te xtLength property returns the total length of the text. Notice that
Te xtLength will include carriage return and linefeed characters in the count when they are
present in a multi-line text box. If the AutoTab property is Tr ue , the focus will be shifted to
the next control in the tab sequence when the maximum number of characters have been
entered into the control.
The CheckBox Control
The CheckBox control provides the user a way to chose between two values, such as Yes and
No, True and False, and Enabled or Disabled. The text in the Caption property is displayed
next to the check box.
The Click and Change events in this control accomplish the same thing because to change the
check box’s value, the user simply clicks anywhere over the control, including the caption.
You can display the value of the CheckBox control by using code like this in the check box’s
Private Sub CheckBox1_Change()
MsgBox "Value of checkbox is " & CheckBox1.Value