me! or me. 2

[flyagain]

Is there a difference between the use of me!controlname and me.controlname in VBA code?

 

[psemianonymous]

There is a difference. I pulled this off of a newsgroup thread:

Remember that the exclamation mark (!) is
used to refer to user objects (say controls or user properties) while
the period (.) is used to refer to native ones (color, size, etc).


thread:

http://groups.google.com/groups?hl=...tabases.ms-access&hl=en&lr=&ie=UTF-8&oe=UTF-8

Ick, apparently, this is some sort of controversy--it even has a name: "dot/bang". Here's an article:

http://www.advisor.com/Articles.nsf/aid/BAROA06

My (shorter) answer than all these is that in most all cases, you will not notice any difference between using the dot(.) and the bang(!).

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[BillPower]

Hi,

. tells Access that you are referring to a form, report or control property.

! tells Access that you are referring to a form or report control

This site is the best I've ever seen for explaining where to use your .'s and !'s

http://www.mvps.org/access/forms/frm0031.htm

All the best

Bill

 

[hwkranger]

Excellent Information!! Kudo's to you guys!

Randall Vollen
National City Bank Corp.