Difference between dot and bang notation?

On Feb 16, 10:02 am, "Richard" <richard.goo...@devenezia.comwrote:

What is the difference between

Me.Lastname
Me!Lastname

TIA

The difference ultimately is where you use them and for what
reference. You can't reference a property or method with ! - just
objects. I have seen a lot of opinion about which is better used
where, but the practise I follow is...

- ! for an internal control reference. Eg. Code in a form module
refering to a control on the same form. - Me!Lastname
- . for an external reference and for properties and methods. Eg. in a
standard module - Forms("frmName").LastName.Visible

Richard wrote:

What is the difference between

Me.Lastname
Me!Lastname

In my own opinion, ultimately, the use of the dot lets you harness the
intellisense from the VBA which makes things much easier for code writing.

I've never had any problem using it.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me

"Richard" <ri************@devenezia.comwrote in
news:11**********************@t69g2000cwt.googlegr oups.com:

What is the difference between

Me.Lastname
Me!Lastname

TIA

In theory, the dot refers to a property of an object, The bang
refers to a member of a collection.

In practice, controls on a form are considered like properties,
even though they are members of the form/report's controls
collection.

Use the dot except when it doesn't work About the only place I
can think of where it doesn't work is in a recordset when
referring to the fields by name.

rs1.fields("myField") and rs1!myfield will work.
rs1.myfield will trigger an error.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

On 16 Feb 2007 07:11:54 -0800, "storrboy" <st******@sympatico.ca>
wrote:

>On Feb 16, 10:02 am, "Richard" <richard.goo...@devenezia.comwrote:

>What is the difference between

Me.Lastname
Me!Lastname

TIA

The difference ultimately is where you use them and for what
reference. You can't reference a property or method with ! - just
objects. I have seen a lot of opinion about which is better used
where, but the practise I follow is...

- ! for an internal control reference. Eg. Code in a form module
refering to a control on the same form. - Me!Lastname
- . for an external reference and for properties and methods. Eg. in a
standard module - Forms("frmName").LastName.Visible

That's funny. I do the complete opposite of both those scenarios!

When I am writing code and want to reference a control on a form,
Access 2003 automatically locates the control if I type "dot" after Me
(Me.txtStartDate).

-pw