Me! vs Me.

[don0110]

Could someone please tell me the difference between Me ! fieldname.value and Me . fieldname.value (without the spaces of course).


Thanks

[FishVal]

Could someone please tell me the difference between Me ! fieldname.value and Me . fieldname.value (without the spaces of course).


Thanks

Dot operator gives reference to object property/method.
Bang operator gives reference to collection member.

You are confused bkz Form_<form name> object contains Controls collection which is the default property, so
Me![control name] is actually Me.Controls![control name]
Pay attention, ! gives reference to a control - member of Controls collection

additionally Form_<form name> object contains property for each control returning that particular control, so
Me.[control name] is a reference to [control name] property returning corresponding control object (just a function created specially to return one particular member of controls collection, just like shortcut).

You may also take a look at this .