[RESOLVED] Me!Text1 = Me.Text1 ???

[reacen]

hi, I found for the 1st time, a source-code where a guy uses "!" instead of "." to access the controls of a Form !

eg:

Msgbox Form1.Text1.Text

is the same as :

Msgbox Form1!Text1.text

(After making my tests, I noted that: use the "!" will point only to the controls, and not work with properties! (Me!Caption will not work))

But, i need more informations about that, is ther something else i dont know ?

[seenu_1st]

yes u r right its working only for controls, thanks for ur info...

[RobDog888]

Office VBA also uses this optional notation but for objects

Ex...
Access:
Form1!TextBox1.Text

[dilettante]

The default property of a Form is a hidden property named [_Default] which normally holds a reference to the Form's Controls collection.

The "bang" (!) syntax is usable for access to a collection object's Item property. Using various levels of default properties, these all produce the same result when used in Form1:

    MsgBox Form1.[_Default].Item("Command1").Name
    MsgBox Form1!Command1.Name
    MsgBox Form1.Controls("Command1").Name
    MsgBox Form1.Controls.Item("Command1").Name
    MsgBox Form1.Controls!Command1.Name
    MsgBox Command1.Name

[reacen]

Woow thanks dilettante