How can I reference the value of some form control when it is NOT stored in the ".text" property ? I tried using the "Controls" collection, but the following code

SomeVariable = MyForm.Controls(Index).Text

is of no use (as it is with textboxes), and

SomeVariable = MyForm.Controls(Index).Checked

does not work, although in a checkbox that's where the value is stored (and not in .text property).

TIA

One way to use the "Checked" property is with an IF statement:

Dim strColor As String
If MyForm.Controls(Index).Checked Then
   strColor = "Blue"
Else
   strColor = "Red"
End If




Dude